语法格式:
while 条件
begin
.......
end
declare @num int=100 while @num > 99 begin update SDetail set SName='达文西-屌' where SScore>99 set @num=@num-10 end
语法格式:
while 条件
begin
.......
end
declare @num int=100 while @num > 99 begin update SDetail set SName='达文西-屌' where SScore>99 set @num=@num-10 end
转载于:https://www.cnblogs.com/qq1981684148/p/6915017.html