求sql循环插入脚本.

[HeIsAHandsome]

Table:Test
一个字段:age

我想插入30条记录，使age的值从1到30,

请问这段语句怎么写。
想在查询分析器里执行。。

谢谢了

[friendliu]

declare @count_num int
set @count_num=1
while @count_num<31
begin
insert into test(age) select @count_num
set @count_num=@count_num+1
end
go

[paoluo]

Create table TEST(age Int)
GO
Declare @I Int
Set @I=1
While @I<31
Begin
Insert TEST Values(@I)
Set @I=@I+1
End
GO
Select * from TEST
GO

Drop table TEST

[paoluo]

晕啊，怎么老是落后啊。

[ReViSion]

declare @I smallint
set @i=1
while @i<=30
begin
insert into Test(age)
select @i

set @i=@i+1
end