if exists(select * from sysobjects where id = object_id(N'dbo.test_cursor') and type = 'P')

drop PROCEDURE dbo.test_cursor

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE PROCEDURE test_cursor

AS

Declare @acctNbr varchar();

Declare @acctName nvarchar();

Declare MyCursor Cursor

for Select AcctNbr,AcctName From base._Member Order By ID

Open MyCursor

Fetch next From MyCursor

Into @acctNbr,@acctName

while(@@fetch_status=)

     begin

          begin

                Select @acctNbr = Convert(varchar(),@acctNbr)

                Select @acctName = Convert(nvarchar(),@acctName)

                print N'会员卡号：'+@acctNbr + N'-----会员姓名：' + @acctName

          end

          fetch next From MyCursor Into @acctNbr,@acctName

     end

Close MyCursor

Deallocate MyCursor

--execute test_cursor