--1.while循环
create table tb(col1 varchar(10),col2 varchar(10),col3 varchar(10))
go
declare @n int
set @n=10
while(@n>0)
begin
insert into tb select 'a','b','c'
set @n=@n-1
end
select * from tb
drop table tb
go
--2.top
create table tb(col1 varchar(10),col2 varchar(10),col3 varchar(10))
go
declare @n int
set @n=10
declare @sql varchar(8000)
set @sql='insert into tb select top '+rtrim(@n)+' ''a'',''b'',''c'' from syscolumns a,syscolumns b'
exec(@sql)