Cursor in SQL Server

Question

Hi... How can we define Cursor in SQL Server and how many type of cursor are use it?

Ankit Shivnakr · Answer

Hi DECLARE @fName varchar(50) @lName varchar(50) DECLARE cursorName CURSOR -- Declare cursor LOCAL SCROLL STATIC FOR Select firstName lastName FROM myTable OPEN cursorName -- open the cursor FETCH NEXT FROM cursorName INTO @fName @lName PRINT @fName + ' ' + @lName -- print the name WHILE @@FETCH_STATUS = 0 BEGIN FETCH NEXT FROM cursorName INTO @fName @lName PRINT @fName + ' ' + @lName -- print the name END CLOSE cursorName -- close the cursor DEALLOCATE cursorName -- Deallocate the cursor

Vulpes · Answer

A similar question was answered here: http://www.c-sharpcorner.com/Forums/Thread/153980/cursors-in-sql.aspx