SQL游标

最新推荐文章于 2024-07-09 08:23:38 发布

weixin_30780221

最新推荐文章于 2024-07-09 08:23:38 发布

阅读量56

点赞数

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/zhangzhu/archive/2012/06/11/2545266.html

declare cursor1 cursor for
select Id,Number from [Contract].[dbo].[Apply] where Number != null or Number != ''

declare @id uniqueidentifier;
declare @number nchar(20);
declare @year nchar(10);
declare @companyno nchar(10);
declare @contractno int;

open cursor1;
fetch next from cursor1 into @id,@number;

while @@FETCH_STATUS = 0
begin
     select @companyno = [Value] from [dbo].[SplitString2](@number, '-', 1)
     update [Contract].[dbo].[Apply] set CompanyNo = @companyno where Id = @id;
     fetch next from cursor1 into @id, @number;
end

close cursor1;
DEALLOCATE cursor1;QL