优快云 6428632条数据sqlserver 38s插入完毕

iteye_13003

于 2011-12-24 14:32:28 发布

阅读量127

点赞数

CC 4.0 BY-SA版权

分类专栏： JAVA 乔乐共享 sqlserver 文章标签：乔乐共享大数据 sqlserver csdn

本文链接：https://blog.youkuaiyun.com/iteye_13003/article/details/82238013

JAVA 乔乐共享同时被 2 个专栏收录

144 篇文章

订阅专栏

sqlserver

6 篇文章

订阅专栏

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.youkuaiyun.com.sql'
with(
	--FORMATFILE = 'C:\BCPFORMAT.xml',
	--FirstRow --default 1
	--KEEPIDENTITY,
	fieldterminator = ' # ',
	rowterminator = '\n'
)

[size=xx-large][color=red]耗时：00:00:38[/color][/size]