What is the use of a cursor in SQL Server

0 votes
I want to utilise a database cursor, but before I can, I need to know what it does, how to use it, and when we can use it in stored methods. Do various SQL Server versions have distinct syntaxes?

When is its use required?
Sep 12 in Database by Kithuzzz
• 20,660 points
83 views

1 answer to this question.

0 votes
Instead of receiving a result set as is, you can use cursors to specifically iterate through its rows.

Cursors are typically something to be avoided within SQL Server stored procedures if at all possible. If you can write a query without using cursors, you give the optimizer a much better chance to find a quick way to implement it. However, they may be more comfortable to use for programmers used to writing While Not RS.EOF Do...

Sincerely, aside from a few administrative activities like running through every index in the catalog and recreating it, I've never found a use case for a cursor that couldn't be avoided. They might be useful for mail merges or report generation, I suppose, but it's probably more effective to do cursor-like tasks in a database-connected program so the database engine can focus on its strongest suit: set manipulation.

I hope this helps you.
answered Sep 13 by narikkadan
• 37,660 points

Related Questions In Database

0 votes
0 answers

What is the syntax to drop a Stored Procedure in SQL Server 2000?

In SQL Server 2000, how do you ...READ MORE

Aug 25 in Database by Kithuzzz
• 20,660 points
77 views
0 votes
1 answer

What is the syntax of USE statement in MySQL?

The USE statement is used to mention ...READ MORE

answered Nov 27, 2018 in Database by Sahiti
• 6,380 points
347 views
0 votes
1 answer

What is the definition of cardinality in SQL?

Cardinality is defined as the "number of ...READ MORE

answered Feb 15 in Database by Neha
• 8,940 points
497 views
0 votes
0 answers

What is the definition of cardinality in SQL?

My book definition of Database Systems does ...READ MORE

Feb 18 in Database by Neha
• 8,940 points
235 views
0 votes
1 answer

Calculate Time Intersection to Correlate Sequences of Independent Events

I think this solution requires a CROSS JOIN implementation. ...READ MORE

answered Oct 26, 2018 in Power BI by Upasana
• 8,620 points
346 views
0 votes
1 answer

What are the different authentication modes in SQL Server? How can it be changed?

Windows mode and Mixed Mode – SQL ...READ MORE

answered Oct 29, 2018 in Database by Sahiti
• 6,380 points
684 views
0 votes
1 answer

Time Series Chart in Power BI

Your Date format should be handled by ...READ MORE

answered Nov 26, 2018 in Power BI by Upasana
• 8,620 points
3,662 views
0 votes
1 answer

Power BI Using SQL Server stored procedures

NOTE: The following works for the "Import ...READ MORE

answered Dec 14, 2018 in Power BI by Upasana
• 8,620 points
5,379 views
0 votes
1 answer

What is the equivalent of 'describe table' in SQL Server?

Use the sp_columns stored procedure: exec sp_columns MyTable I hope this ...READ MORE

answered Sep 17 in Database by narikkadan
• 37,660 points
48 views
0 votes
1 answer

Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452) in sql 2008

Solution Go to Start > Programs > Microsoft SQL Server > Enterprise Manager. Right-click the SQL ...READ MORE

answered Sep 12 in Database by narikkadan
• 37,660 points
144 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP