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
Sep 04, 2012 at 12:34 AM
Feb 13, 2013 at 02:45 PM
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.
Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.
Once you sign in you will be able to subscribe for any updates here
Answers and Comments
Need long-form SQL discussion? SQLserverCentral.com is the place.
asked: Sep 04, 2012 at 12:34 AM
Seen: 802 times
Last Updated: Sep 20, 2012 at 03:29 PM
SQl Database in 2005
End of support for Sql Server 2005
SQL Server Agent 2005 and SSIS
How can you get indexes replicated in sql 2005
Deadlock Problem With UPDATE
How can I create .csv file in SQL Server 2005 with table data?
Backing up data between SQL Express 2005 and SQL Server 2008 Standard Edition
Page Granularity Locking
How to import bulk .log files and add a column to the table
how to write subquery in the insert sql server 2005