cursor in Sql Server

 

Thank you.

Cursors enable manipulation of whole result sets at once. In this scenario, a cursor enables the rows in a result set to be processed sequentially. In SQL procedures, a cursor makes it possible to define a result set (a set of data rows) and perform complex logic on a row by row basis.

 

Also Advantages of using Cursor: Using Cursor we can perform row by row processing so we can perform row wise validation or operations on each row. Cursors can provide the first few rows before the whole result set is assembled

Hello

 

Well its totally depends on your requirement that when to use and when to do not use 

 

Why we can use cursor ?

 

If we want to perform something frequently at counter basis , i mean repeated task before or after any other data manipulation , at that time we can use cursor 

 

cursor is alternative for views or sub queries 

 

Advantages :

 

- perform row by row operation 

- in some case , its fater than while loop for frequent operations 

 

Disadvantages : 

 

- speed may be major issue 

- consumes high network bandwidth at some point of time

 

For more reference about cursor you can follow few links :

 

What is cursor  ?

 

http://www.webcodeexpert.com/2013/11/what-is-cursor-advantages-and.html 

 

http://searchsqlserver.techtarget.com/feature/Part-3-Cursor-disadvantages 

 

How to use cursor ?

 

http://www.webcodeexpert.com/2013/11/use-of-cursor-in-sql-server-with-simple.html

 

I hope you will get more idea about that

 

Thanks