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

what use of Sql server Cursor....

Answers (2)