SQL - 循环

最新推荐文章于 2024-01-03 11:23:10 发布

weixin_30825581

最新推荐文章于 2024-01-03 11:23:10 发布

阅读量47

点赞数

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/LYshuqian/p/3211003.html

SQL - 循环

 declare @itemnumber int --定义需要循环的次数
 declare @tagint int --定义标志字段，用于结束循环
 set @tagint=1
 select @itemnumber = count(distinct Creater) from Demo_TestTable where isnull(Creater,'')<>'' And 
　  DATEDIFF(DAY,CreatDate,GETDATE())<1
   if(@itemnumber>0)
   begin
     while @tagint<=@itemnumber
         begin
             waitfor delay '00:00:01' --每隔一秒再执行 可用参数变量替换
             Update Demo_TestTable set CreatDate=GETDATE() where Creater =(
             Select Creater from (
                 select Creater,ROW_NUMBER() over(order by Creater) as RowID from Demo_TestTable where 
　　　　　　　　　　　　isnull(Creater,'')<>'' And DATEDIFF(DAY,CreatDate,GETDATE())<1 group by Creater
              ) TableA
              where  TableA.RowID=@tagint
              )
              set @tagint=@tagint+1
         end
   end