Totul despre cursori si toate functiile cursor

March 5, 2010

— Tutorial 5: Cursor Functions link general: http://doc.ddart.net/mssql/sql70/fa-fz_18.htm

–These scalar functions return information about cursors. @@ -functie scalara

–Returns the number of qualifying rows that are currently in the last cursor opened on the connection. To improve performance, Microsoft® SQL Server™ can populate large keyset and static cursors asynchronously. @@CURSOR_ROWS can be called to determine the number of the rows that qualify for a cursor have been retrieved at the time @@CURSOR_ROWS is called.


–A scalar function that allows the caller of a stored procedure to determine whether or not the procedure has returned a cursor and result set for a given parameter.


–Returns the status of the last cursor FETCH statement issued against any cursor currently opened by the connection.



Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: