mssql 循环语句写法

最新推荐文章于 2023-10-12 16:49:45 发布

Hiirhan

最新推荐文章于 2023-10-12 16:49:45 发布

阅读量1.1k

点赞数

分类专栏： sqlServer

本文链接：https://blog.csdn.net/wzx_it/article/details/7023766

版权

sqlServer 专栏收录该内容

17 篇文章 0 订阅

订阅专栏

declare @itemnumber int -- 定义需要循环的次数
2 declare @tagint int -- 定义标志字段，用于结束循环
3 set @tagint = 1
4 select @itemnumber = count ( distinct Creater) from Demo_TestTable where isnull (Creater, '' ) <> '' And
　 DATEDIFF ( DAY ,CreatDate, GETDATE ()) < 1
5    if ( @itemnumber > 0 )
6    begin
7      while @tagint <= @itemnumber
8          begin
9              waitfor delay ' 00:00:01 ' -- 每隔一秒再执行可用参数变量替换
10              Update Demo_TestTable set CreatDate = GETDATE () where Creater = (
11              Select Creater from (
12                  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
13              ) TableA
14               where   TableA.RowID = @tagint
15              )
16               set @tagint = @tagint + 1
17          end
18    end