How to insert hundreds of pieces of data into the database

shenyang

How do you prawn insert millions of data into the database, speed up, thank you

恶魔右指

create table ta (id int)
go
declare @i int, @j int
select @ i = 1, @ j = 100
while @i!> @ j
begin
insert ta select @i
set @ i = @ i + 1
end
select * from ta

恶魔右指

create table ta (id int)
go
declare @i int, @j int
select @ i = 1, @ j = 1000000--define one million
while @i!> @ j
begin
insert ta select @i
set @ i = @ i + 1
end
select * from ta

恶魔右指

create table ta (name1, name varchar (100))
set rowcount 1000000
insert ta
select a.name from sysobjects a, syscolumns b
set rowcount 0

shenyang

Thank you