The @@sqlstatus global variable holds status information (warning exceptions) resulting from the execution of a fetch statement. Its value reflects the last cursor fetched.
The @@fetch_status global variable provides information about whether fetch is executed successfully in a scrollable cursor.
Saturday, January 31, 2009
differnce between @@sqlstatus and @@fetch_status
Labels:
SQL,
SQL Server,
SQL Server Tips,
Vijaya Kadiyala
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment