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
相关阅读 更多 +
