sqlserver 預存程序 遊標執行個體

標籤：eal   ext   預存程序   ber   color   arch   close   for   exe   

if exists(select * from sysobjects where id = 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(100);Declare @acctName nvarchar(100);Declare MyCursor Cursorfor Select AcctNbr,AcctName From base._Member Order By IDOpen MyCursorFetch next From MyCursor Into @acctNbr,@acctNamewhile(@@fetch_status=0)     begin          begin                Select @acctNbr = Convert(varchar(100),@acctNbr)                Select @acctName = Convert(nvarchar(100),@acctName)                print N‘會員卡號：‘[email protected] + N‘-----會員姓名：‘ + @acctName          end          fetch next From MyCursor Into @acctNbr,@acctName     endClose MyCursorDeallocate MyCursor--execute test_cursor

 

sqlserver 預存程序 遊標執行個體