Cursor Functions In SQL Server

Question

What is Cursor function in SQL Server and why is it used ?

Deepak Middha · Answer

A Cursor is a SQL Object or we can say like a Virtual table that retrieves data from the table one row at a time. We use cursors when we need to update records in a database table in singleton fashion in other words row by row. Fore more help visit http://www.c-sharpcorner.com/UploadFile/63f5c2/cursor-in-sql-server/

Satyapriya Nayak · Answer

http://sqlserverpedia.com/wiki/Built-in_Functions_-_Cursor_Functions

Sandeep Singh Shekhawat · Answer

CURSOR : This is actually table created during execution of a T-SQL body . This is used to fetch records from a select query hence helps in manipulating data. http://www.dotnet-tricks.com/Tutorial/sqlserver?id=4L7I050512&title=SQL%20Server%20-%20Basic%20of%20Cursor http://www.dotnet-tricks.com/Tutorial/sqlserver/RLID060512-SQL-Server-Different-Types-of-Cursors.html