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 variabl
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 these
> 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 an
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 stri