|
hi , im using a cursor in a sp,however ,when i declare it,the sp goes to catch block without throwing any error. @@fetch_status gives 0 at the starting of the sp ... is there some thing im missing
(comments are locked)
|
Be the first one to answer this question
Please share some code, it's hard to guess the possible reasons for your code to fail without having seen any of it...
my guess without seeing it, is that the sql query you are putting into the cursor returns no rows.