1 批量插入数据
declare @i int
set @i = 1
while @i <300
begin
insert into relationDepartmentMeter
values(@i,6,@i)
set @i = @i + 1
end
2 将一个表中的数据导入另一个表中
insert into A(a,b,c) (select a,b,c from B)
declare @i int
set @i = 1
while @i <300
begin
insert into relationDepartmentMeter
values(@i,6,@i)
set @i = @i + 1
end
2 将一个表中的数据导入另一个表中
insert into A(a,b,c) (select a,b,c from B)