Hi all,
My basic question is, is there a simple way of finding out if a select
statement executed within a stored proc returns something. I could go ahead,
do the fetch (the query is done with a cursor) and count how many records
were returned but looping over the result. In below proc the
This is a follow-up to the earlier stored proc question.
I have a stored proc, with user level permissions for execute. If I
drop the stored proc and then create it again, the user level execute
permissions go away. What is the proper way to edit/alter a store proc
without losing
I have a string (word word bob jack) such that I want to pass to the
store proc as a single entity,
split it in the store proc, and do a specific action for each word. Any
advice on how to do this? There is more going on that just that single
word so multiple calls isn't practical and they
I have a string (word word bob jack) such that I want to pass to the
store proc as a single entity,
split it in the store proc, and do a specific action for each word.
Any
advice on how to do this? There is more going on that just that
single
word so multiple calls isn't practical and they
