Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Can I execute a stored procedure without getting a result?
Hi pgtek! I dont understand how this can help me. Can you explain it further please? Regards Galore- galore
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Can I execute a stored procedure without getting a result?
I am trying to do something like this inside a stored procedure: EXEC searchEvent 'Exhibition' IF @@ROWCOUNT > 0 BEGIN SELECT 'EXHIBITION' END The problem is that searchEvent returns a record set. This way i got two record set. How can I do the test if searchEvent returns anything without...- galore
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
