insert into tablename values('001','1111');
insert into tablename values('002','1111');
insert into tablename values('003','1111');
insert into tablename values('004','1111');
有没有什么方法,可以同时插入上面这几条数据呢?
不用每次都insert into XX valuesXXX
(用Excel 导入出外,其他的方法)
方法:
declare @i int
declare @s varchar(4)
set @i=1
while @i<100
begin
set @s=convert(varchar(2),@i)
set @s=right('00'+@s,3)
insert into tablename values(@s,'1111');
set @i=@i+1
end
declare @i int
set @i=0001
while @i<4
begin
insert into tablename (字段1,字段2) values(@i,'1111')
set @i=@i+1
end
set @i=0001
while @i<4
begin
insert into tablename (字段1,字段2) values(@i,'1111')
set @i=@i+1
end