declare @month int
set @month=1while @month<13
begin
insert into tblTest(monthField) values (@month)
set @month=@month+1
end
set @month=1while @month<13
begin
insert into tblTest(monthField) values (@month)
set @month=@month+1
end
set @i = 1
while @i <= 12
begin
insert test select @i
set @i = @i+1
end
select * from testdrop table test
select top 12 (select sum(1) from sysobjects where id<=a.id) 时间 from sysobjects a
m int
)declare @i int
set @i = 1
while @i<=12
begin
insert into test values (@i)
set @i = @i + 1
endselect * from test