SQL server数据库块编程代码

 1 declare @N int=0
 2 while @N<=100
 3 begin
 4 print @N;
 5 begin
 6 if @N%2=0
 7 print getdate();
 8 else
 9 select GETDATE();
10 end
11 set @N=@N+1
12 end
View Code

 

posted @ 2019-05-15 13:50  星空沃土  阅读(195)  评论(0编辑  收藏  举报