::
::
::
::
::
- sp_configure 'show advanced options',1
- go
-
- sp_configure 'Ad Hoc Distributed Queries',1
- go
-
- reconfigure with override
- go
-
- sp_configure 'xp_cmdshell',1
- go
- reconfigure
- go
-
-
- create database wc
- go
-
-
- use wc
- go
-
-
- create table xxdd
- (
- aa nvarchar(1000),
- bb nvarchar(1000),
- cc nvarchar(1000),
- dd nvarchar(1000),
- ee nvarchar(1000),
- ff nvarchar(1000)
- )
- go
-
-
-
- exec xp_cmdshell 'bcp wc.dbo.xxdd format nul -t "," -f c:\wc.fmt -c -Usa -Pyupeigu -S 192.168.1.106,1433'
- go
-
-
- /* 这里建立一个c:\wc.csv 文件,内容如下:
- aa,bb,cc,dd,ee,ff
- 42222222223432432432,32432432432432432432,2332432432,32432432432,32432432,23432432
- 42222222223432432432,32432432432432432432,2332432432,32432432432,32432432,23432432
- 42222222223432432432,32432432432432432432,2332432432,32432432432,32432432,23432432
- 42222222223432432432,32432432432432432432,2332432432,32432432432,32432432,23432432
-
- */
-
-
-
- select *
- from
- openrowset(bulk 'c:\wc.csv',
- formatfile='c:\wc.fmt',
-
- firstrow = 2,
-
-
- maxerrors = 10,
-
-
- rows_per_batch = 10000
- ) as t
-
- /*
- aa bb cc dd ee ff
- 42222222223432432432 32432432432432432432 2332432432 32432432432 32432432 23432432
- 42222222223432432432 32432432432432432432 2332432432 32432432432 32432432 23432432
- 42222222223432432432 32432432432432432432 2332432432 32432432432 32432432 23432432
- 42222222223432432432 32432432432432432432 2332432432 32432432432 32432432 23432432
- */
-
-
-
- insert into xxdd (aa,bb,cc,dd,ee,ff)
- select *
- from
- openrowset(bulk 'c:\wc.csv',
- formatfile='c:\wc.fmt',
-
- firstrow = 2,
-
-
- maxerrors = 10,
-
-
- rows_per_batch = 10000
- ) as t
-
-
-
- select *
- from xxdd
posted on
2015-11-02 16:05
微笑点燃希望
阅读(
453)
评论()
编辑
收藏
举报
font=white