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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.