print sql-server | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

print sql-server

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 [email protected])<1
begin select @ne1=(select campo2 from tabla3 where [email protected])
insert into tabla3 values(@param1,@ne1)
begin print ‘already in the table’
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.[?]
Please move this post to Developer Forum.
Kindly don’t duplicate posts.
Luis Martin
Moderator All postings are provided “AS IS” with no warranties for accuracy.
Follow as suggested and further discussion here. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.