Cursor Functions In SQL Server

Question

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

Vishal Yelve · Answer

Hi Surrbhi, Cursor is a database object to retrieve data from a result set one row at a time, instead of the T-SQL commands that operate on all the rows in the result set at one time. We use a cursor when we need to update records in a database table in singleton fashion means row by row. Syntax DECLARE cursor_name CURSOR [LOCAL | GLOBAL] --define cursor scope [FORWARD_ONLY | SCROLL] --define cursor movements (forward/backward) [STATIC | KEYSET | DYNAMIC | FAST_FORWARD] --basic type of cursor [READ_ONLY | SCROLL_LOCKS | OPTIMISTIC] --define locks FOR select_statement --define SQL Select statement FOR UPDATE [col1,col2,...coln] --define columns that need to be updated Do refer below link https://www.c-sharpcorner.com/UploadFile/f0b2ed/cursors-in-sql/ https://learn.microsoft.com/en-us/sql/t-sql/language-elements/declare-cursor-transact-sql?view=sql-server-ver16 https://www.dotnettricks.com/learn/sqlserver/sql-server-basics-of-cursors https://www.mssqltips.com/sqlservertip/1599/cursor-in-sql-server/

Rajeev Kumar · Answer

A cursor in SQL Server is a database object that allows us to retrieve each row at a time and manipulate its data . A cursor is nothing more than a pointer to a row. It's always used in conjunction with a SELECT statement.

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

Cursor Functions In SQL Server

Answers (5)