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)
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.[?]
Please move this post to Developer Forum.
Kindly don’t duplicate posts.
Luis Martin
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.
Follow as suggested and further discussionhttp://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=4758 here. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>