使用的sql 语句如下:
declare
@userid int ;
set @userid=0
while(@userid<20)
begin
print 'the result is :'+STR(@userid);
set @userid=@userid+1;
end
测试的结果如下:
the result is : 0
the result is : 1
the result is : 2
the result is : 3
the result is : 4
the result is : 5
the result is : 6
the result is : 7
the result is : 8
the result is : 9
the result is : 10
the result is : 11
the result is : 12
the result is : 13
the result is : 14
the result is : 15
the result is : 16
the result is : 17
the result is : 18
the result is : 19
还是比较简单的,但是相对于oracle 没有for 循环 感觉还是不太方便