复制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 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.WordPress模板 |
喜欢
讨厌