Why cursor is used in sql server ?

Question

0.00/5 (No votes)

See more:

ASP.NET

Hi,

Please tel me
What is the need for using cursor?
what is the advantage of using cursor?

Posted 28-Feb-13 20:47pm

Rohit Kolekar11

Add a Solution

4 solutions

Solution 1

hi,

Cursor is nothing but a for loop concept. While you returning some recordset and doing functionality with the same procedure. As the basic advise dont use cursor. It creates lot of performance issue. Executing time is getting more while used cursors. Main disadvantage is it allocates lot of memory on server. Better use temp table concept to avoid cursors.

Regards,
Prakash.T

Posted 28-Feb-13 21:27pm

Prakash Thirumoorthy

Comments

Rohit Kolekar11 1-Mar-13 5:38am

Thanks...

Solution 2

This might help you -> http://bradsruminations.blogspot.in/2010/05/[^]

Posted 28-Feb-13 21:36pm

LaxmikantYadav

Comments

Rohit Kolekar11 1-Mar-13 5:39am

Thanks...

Solution 4

Please follow the links below

http://en.wikipedia.org/wiki/Cursor_(databases)[^]
http://stackoverflow.com/questions/4222868/what-is-exact-use-of-cursor-in-sql-server[^]

Thanks

Posted 28-Feb-13 21:42pm

AshishChaudha

Comments

Rohit Kolekar11 1-Mar-13 5:38am

Thanks...

AshishChaudha 1-Mar-13 23:39pm

Welcome rohit...

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

*Karthik Harve* · Accepted Answer · 2013-02-28T21:38:00

Solution 3

Hi,

Cursor is basically a pointer which help us to iterate through the rows of the specified record set. refer below articles for more on cursors.

SQL Server Basics of Cursors[^]
Cursors[^]
SQL Server Different Types of Cursors[^]
What is cursor in SQL Server?[^]
Cursors: An Overview[^]

hope it helps.

Posted 28-Feb-13 21:38pm

Karthik Harve

Comments

Rohit Kolekar11 1-Mar-13 5:38am

Thanks....

Karthik Harve 1-Mar-13 5:40am

Welcome.! happy coding.

fjdiewornncalwe 1-Mar-13 17:39pm

+5.

Karthik Harve 1-Mar-13 23:44pm

Thanks.!