要这样吗? declare @num int set @num=0 while @num<10 begin insert into table_name (a,b) values ('学生',‘教师’) set @num=@num+1 end
create table test1 (t varchar(10),s varchar(10)) declare @i int select @i=1 while @i<13 begin select @i=@i+1 insert into test1 (t,s) values ('老师','学生')end
CREATE TABLE TB(a VARCHAR(10),b VARCHAR(10)) DECLARE @sql VARCHAR(1000) SET @sql='INSERT TB SELECT ''学生'',''教师''' SELECT TOP 9 @sql=@sql + ' UNION ALL SELECT ''学生'',''教师''' FROM sysobjects EXEC (@sql) SELECT * FROM tbDROP TABLE TB
--如果一次插入的很多,这样效率高些 create table tb(a varchar(10),b varchar(10)) goinsert into tb select top 10 '老师' as a,'学生' as b from syscolumns a,syscolumns b goselect * from tbdrop table tb
declare @num int
set @num=0
while @num<10
begin
insert into table_name (a,b) values ('学生',‘教师’)
set @num=@num+1
end
declare @i int
select @i=1
while @i<13
begin
select @i=@i+1
insert into test1 (t,s)
values ('老师','学生')end
DECLARE @sql VARCHAR(1000)
SET @sql='INSERT TB SELECT ''学生'',''教师'''
SELECT TOP 9 @sql=@sql + ' UNION ALL SELECT ''学生'',''教师''' FROM sysobjects
EXEC (@sql)
SELECT * FROM tbDROP TABLE TB
create table tb(a varchar(10),b varchar(10))
goinsert into tb select top 10 '老师' as a,'学生' as b from syscolumns a,syscolumns b
goselect * from tbdrop table tb
牛,原来还可以这么写