C# Tutorials and offshore development in India

Prizes & Awards

My Profile

AdSense Revenue

Active Members
Today

Last 7 Days

more...

New Feature: Community Sites: Create your own .NET community website and start earning from Google AdSense ! It's Free !

How to get the number of qualifying rows currently in the last cursor opened on the connection

Posted Date: 05 Mar 2008 Resource Type: Code Snippets Category: SQL

Posted By: Ashwini Rupert Member Level: Diamond
Rating:

Points: 10

The following code snippet will give the number of qualifying rows currently in the last cursor opened on the connection in SQL Server. To improve performance, Microsoft SQL Server can populate large keyset and static cursors asynchronously. @@CURSOR_ROWS can be called to determine that the number of the rows that qualify for a cursor are retrieved at the time @@CURSOR_ROWS is called.

								

USE DATABASE
GO

SELECT @@CURSOR_ROWS

DECLARE Name_Cursor CURSOR FOR
          SELECT 
                LastName ,
               @@CURSOR_ROWS 
          FROM 
               tablename

OPEN Name_Cursor

FETCH NEXT FROM Name_Cursor

SELECT @@CURSOR_ROWS

CLOSE Name_Cursor

DEALLOCATE Name_Cursor

GO

Responses

Author: Kapil Dhawan 17 Jun 2008 Member Level: Gold Points : 2

Hello
Nice piece of code
Thanks for sharing your knowledge with us.
I hope to see more good code from your side
This code will help lots of guys
Thanks to you
Regards,
Kapil

Feedbacks

Popular Tags

What are tags ?

Search Tags

(No tags found.)

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: How to use switch case in SQL server
	Previous Resource: What is the use of @@DATEFIRST function in SQL Server
	Return to Discussion Resource Index
	Post New Resource
	Category: SQL

Post resources and earn money!

Related Resources

dotNet Slackers BizTalk Adaptors Web Design

efax