SQL循环语句

while 条件(@i<10)
  begin
       语句
    set @i = @i + 1
  end

循环插入语句
declare @i int
set @i = 31
while @i < 560
begin
insert into DATATABLE (QNO) values (@i')
set @i = @i+1
end

SQL语句中的循环

DECLARE @i int
DECLARE @strUserId varchar(10)
DECLARE @strAuthnum varchar(10)
Set @i = 0
WHILE @i < 10000
BEGIN
Set @i =@i +1
SET @strUserId = RIGHT('00000' + CAST(@i AS varchar(10)),5)
SET @strAuthnum = @strUserId
insert into user_info values(@strUserId,@strAuthnum)
END