怎样给数据库插入10000条记录

写一个while循环不就行了嘛

declare @i int=1

while @i<=10000

begin

insert into 表名(id,name) values(@i,'abc')

end

insert into tableNameA select * from tableNameB

如果tableNameB 表了有100W条记录，就会一次插入100W条

---