::
::
::
::
::
|
26 |
27 |
28 |
29 |
30 |
31 |
1
|
2
|
3
|
4
|
5
|
6
|
7
|
8
|
9
|
10
|
11
|
12
|
13
|
14
|
15
|
16
|
17
|
18
|
19
|
20
|
21
|
22
|
23
|
24
|
25
|
26
|
27
|
28
|
1
|
2
|
3
|
4
|
5
|
6
|
7
|
8
|
- 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
微笑点燃希望
阅读(
457)
评论()
编辑
收藏
举报
font=white
点击右上角即可分享
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步