CSDN 6428632条数据sqlserver 38s插入完毕

if exists(select * from sysobjects where name = 'csdn1')
	drop table csdn1
create table csdn1(
	--id int identity(1,1) primary key,
	username varchar(50) not null,
	[password] varchar(50) not null,
	email varchar(50) not null
)

bulk insert csdn1
from 'D:\F\Database\password\www.csdn.net.sql'
with(
	--FORMATFILE = 'C:\BCPFORMAT.xml',
	--FirstRow --default 1
	--KEEPIDENTITY,
	fieldterminator = ' # ',
	rowterminator = '\n'
)

耗时：00:00:38