T-SQL 游标

时间：2010-12-16 来源：未来

示例:

代码 declare @DocID char(32)
declare @UserRights varchar(8000)

declare mycursor cursor --定义游标变量
for select DocID,UserRights from dbo.DocIndex_SMCCOA06--从数据表中取出需要的数据集
open mycursor--打开游标
fetch next from mycursor into @DocID,@UserRights--读取游标数据
WHILE ( @@FETCH_STATUS = 0 )
begin
    INSERT INTO [dbo].[DocIndex_Rights]
           ([UserID]
           ,[DocID])
    select short_str,@DocID from  dbo.split(@UserRights,'|')
    fetch next from mycursor into @DocID,@UserRights
end
close mycursor--关闭游标
DEALLOCATE mycursor--销毁游标
go

相关阅读更多 +