1.循环插入: declare @i int --变义变量@i set @i = 1 --初始化@i为1 while @i < 1000000 --如果@i小于100,这里改成100万即是插入100万条记录 begin ------------------ insert into manager (username,userpwd) values('kgdiwss','250') set @i = @i + 1 end --------------------2.根据主键不同插入: 比如:insert into manager(userid,username,userpwd) select (substring(cast(newId() as char(36)),1,14),username,userpwd from manager
declare @i int --变义变量@i
set @i = 1 --初始化@i为1
while @i < 1000000 --如果@i小于100,这里改成100万即是插入100万条记录
begin ------------------
insert into manager (username,userpwd) values('kgdiwss','250')
set @i = @i + 1
end --------------------2.根据主键不同插入:
比如:insert into manager(userid,username,userpwd)
select (substring(cast(newId() as char(36)),1,14),username,userpwd from manager