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;