h1

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

–@@CURSOR_ROWS (T-SQL)
–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.

http://doc.ddart.net/mssql/sql70/globals_2.htm

–CURSOR_STATUS (T-SQL)
–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.

http://doc.ddart.net/mssql/sql70/cr-cz_3.htm

–@@FETCH_STATUS (T-SQL)
–Returns the status of the last cursor FETCH statement issued against any cursor currently opened by the connection.

http://doc.ddart.net/mssql/sql70/globals_6.htm

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: