语法格式:
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