what use of Sql server Cursor....

Question

Hi All I confused about cursor.... What use of cursor in any project.... Please give some example..

Francis · Answer

I confused about cursor. A cursor contains information on a select statement and the rows of data accessed by it. You can loop thru the each record in the cursor. What use of cursor in any project. AFAIK Based on it's nature if you want to loop thru some records and calculate something at that time you may go with cursor. Mostly cursors are used inside a Stored Procedure. It is equivalent as loop thru the collection(such as List) using foreach loop in c#. In realtime projects usage of cursor should be avoided. Since it consumes memory of SQL Server. You can find more disadvantage of cursor in the below url: http://searchsqlserver.techtarget.com/feature/Part-3-Cursor-disadvantages Hope this helps!

Raja T · Answer

Hi if u know about data reader in c# I think same as cursor in SQL. In c# data reader is used get data fro database with connection oriented same here also cursor . More details check out below URLs https://www.mssqltips.com/sqlservertip/1599/sql-server-cursor-example/ http://blog.sqlauthority.com/2007/01/01/sql-server-simple-example-of-cursor/ http://www.dotnet-tricks.com/Tutorial/sqlserver/4L7I050512-SQL-Server-Basics-of-Cursors.html