Sql Cursor

A cursor is a temporary work area created in the system memory when a SQL statement is executed. A cursor contains information on a select statement and the rows of data accessed by it.

EXAMPLE:

DECLARE @ID int,@Name varchar(50)
DECLARE CursorVar CURSOR LOCAL FOR SELECT ID,Name FROM TABLE 
OPEN CursorVar
	FETCH NEXT FROM CursorVar into @ID,@Name
	WHILE @@FETCH_STATUS = 0
	BEGIN
	    SELECT @ID,@Name	 
		FETCH NEXT FROM CursorVar into @ID,@Name
	END 
CLOSE CursorVar
DEALLOCATE CursorVar

• cursor
• ms sql Cursor
• Sql Cursor