Cursor in sql server

Question

Hi friends Can anybody here make a simple cursor which fetch one by one row of a table and call it from asp.net front page.

Pankaj Rana · Answer

Simple cursor example Declare @Lastname varchar(50) DECLARE @Email varchar(20) DECLARE Student_cursor CURSOR FOR Select FirstnameLastnameEmail from student OPEN Student_cursor; FETCH NEXT FROM Student_cursor INTO @Firstname @Lastname @Email; WHILE @@FETCH_STATUS = 0 BEGIN print '---------------' print @Firstname print @Lastname print @Email print '---------------' FETCH NEXT FROM Student_cursor INTO @ItemID; END CLOSE Student_cursor; DEALLOCATE Student_cursor; Refer this http://queriesinsql.blogspot.com/2011/12/cursor-in-sql-with-example.html

Pankaj Rana · Answer

hi Akshay you can create cursor in Stored Procedure and call stored procedure with the help your logical layer and data access layer. Mainly the purpose of cursor is to read single record in forward only manner from a table. So its depends upon you how you want to use cursor in stored procedure.

Akshay Teotia · Answer

thanks pankaj great work. one more thing how i can call this cursor from asp.net front end.