SQL Server stored Procedure cursor instance

ifExistsSelect* fromsysobjectswhereid = object_id (N'Dbo.test_cursor') and type ='P') Drop PROCEDURE dbo.test_cursorgoset ansi_nulls ongoset quoted_identifier ongocreate PROCEDURE test_ Cursorasdeclare @acctNbr varchar ( -);D eclare @acctName nvarchar ( -);D eclare mycursor Cursor forSelect Acctnbr,acctname fromBase. _member Order by Idopen Mycursorfetch next from MyCursor into @acctNbr, @acctName while(@ @fetch_status =0) BEGIN begin Select @acctNbr= Convert (varchar ( -), @acctNbr) Select @acctName= Convert (nvarchar ( -), @acctName) print N'Membership card number:'[Email protected] + N'-----Member Name:'+@acctName end Fetch NEXT from MyCursor to @acctNbr, @acctName endclose mycursordeallocate MYCU Rsor--execute Test_cursor

SQL Server stored Procedure cursor instance