Fetch Record from Cursor in SQL Server

Question

I want to know how to fetch record from cursor in SQL server. Thank you.

Vikrant More · Answer

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

Adil Ansari · Answer

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;