Fetch Record from Cursor in SQL Server

To fetch records from Cursor there are following steps we have to follow,
1] Declare Cursor
2] Open Cursor
3] Fetch Cursor
4] Deallocate Cursor
5] Close Cursor 

#1 To declare cursor use following syntax,
DECLARE CURSOR FAST_FORWARD
FOR 


#2 To Open cursor Syntax,
OPEN

#3 To Fetch Cursor Syntax,
FETCH NEXT FROM INTO

#4] Deallocate Cursor Syntax,
Deallocate

#5] Close Cursor Syntax,
Close

Demo Example of Cursor,



DROP TABLE #Student

CREATE TABLE #Student
(
IStudentID int identity (1, 1)
,vchStudentFirstName varchar(100)
, vchStudentLastName varchar (100)
, vchDepartment varchar (50)
)

INSERT INTO #Student values ('FirstName1','LastName1','BCA')
INSERT INTO #Student values ('FirstName2','LastName2','MCA')
INSERT INTO #Student values ('FirstName3','LastName3','BCS')
INSERT INTO #Student values ('FirstName4','LastName4','BA')


DECLARE @id int


DECLARE LOOP_CUR CURSOR FAST_FORWARD
FOR
SELECT iStudentID from #student (NOLOCK)
--WHERE ACCOUNTID=300001

OPEN LOOP_CUR

FETCH NEXT FROM LOOP_CUR INTO @id

WHILE(@@FETCH_STATUS=0)
BEGIN

select * from #student where iStudentID=@id

FETCH NEXT FROM LOOP_CUR INTO
@id

END

CLOSE LOOP_CUR
DEALLOCATE LOOP_CUR

0

Adil Ansari14y agoPosted Aug 30, 2012, 8:57 AM

Below is an example for cursor in SQL visit here for more details 

DECLARE vend_cursor CURSOR     FOR SELECT * FROM Purchasing.Vendor OPEN vend_cursor FETCH NEXT FROM vend_cursor;

0