语法:
while 条件
begin
一堆sql
end
示例:
declare @num int=1000
while @num > 999
begin
update Stable set SName='123' where SScore>999
set @num=@num-10
end
语法:
while 条件
begin
一堆sql
end
示例:
declare @num int=1000
while @num > 999
begin
update Stable set SName='123' where SScore>999
set @num=@num-10
end