SQL Server Performance

print from sql-server

Discussion in 'Preguntas sobre SQL Server en Español.' started by avilapuig, Jul 2, 2004.

  1. avilapuig New Member

    hello:

    i have this huge problem. it's killing me.i have this store procedure :
    CREATE PROCEDURE siesta

    @param1 int

    AS

    declare @ne1 varchar(20)
    declare @text varchar(20)



    if( select count(*) from tabla3 where campo1=@param1)<1
    begin

    select @ne1=(select campo2 from tabla3 where campo1=@param1)
    insert into tabla3 values(@param1,@ne1)


    end
    else
    begin





    print 'already in the table'
    end
    GO


    the procedure insert if it's not there . and if the person is already in the table send a message. the problem is that i want to call the store procedure from visual basic 6.0
    but i want to see the PRINT 'already in the table'. how can i do it? i've tried several things but ... .

    THANK YOU FOR YOUR HELP.
  2. Luis Martin Moderator

    Please don't duplicate post, and this is a Spanish Forum.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.

Share This Page