@@FETCH_STATUS is -1 when I open a connection

Question

0

Hi,
These are the opening lines of my code

USE myDatabase
GO

PRINT '@@FETCH_STATUS: ' + CAST(@@FETCH_STATUS AS nvarchar(30))

This returns FETCH_STATUS as -1. I have just opened the connection. Can anyone tell me why this is occuring?

mssql

2

Contributors

1

Reply

2

Views

5 Years

Discussion Span

5 Years Ago

Last Post by atinobrian

This Question has been Answered

atinobrian 7 · Answer 1 · 2012-07-18T02:34:42+00:00

@@Fetch_Status Returns the status of the last cursor FETCH statement issued against any cursor currently opened by the connection.
Since you have not opened a Cursor yet , its giving -1 as a value.
check this msdn article for more details
http://msdn.microsoft.com/en-us/library/ms187308.aspx