Simple usage of SQL Server cursors

SQL Server cursors:

--Defining cursors

Declare cursor1 cursor FOR select Id,name from A

--Open cursor

Open Cursor1

DECLARE @id int

DECLARE @name varchar (50)

DECLARE @n int

DECLARE @i int=1

Set @n= (select COUNT (1) from A)

while (@i<@n)

Begin

Set @[email protected]+1

FETCH NEXT from Cursor1 to @id, @name

Select @id Select @name

End

--Close cursor

Close Cursor1

--Releases the cursor and cannot open the cursor after it is released.

Deallocate Cursor1

Simple usage of SQL Server cursors