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

if exists(select * from sysobjects where name = 'csdn1')	drop table csdn1create 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 csdn1from 'D:\F\Database\password\www.csdn.net.sql'with(	--FORMATFILE = 'C:\BCPFORMAT.xml',	--FirstRow --default 1	--KEEPIDENTITY,	fieldterminator = ' # ',	rowterminator = '\n')