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')
