-
【SQL Server数据迁移】把csv文件中的数据导入SQL Server的方法
- 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
-
相关阅读:
基于Vue.js的表格分页组件
浅谈Vue.js
利用js2image把代码压缩成圣诞树
在AngularJS中的使用Highcharts图表控件
使用Uploadify(UploadiFive)多文件上传控件遇到的坑
iOS开源项目周报0323
安卓开源项目周报0322
前端开源项目周报0321
iOS开源项目周报0316
安卓开源项目周报0315
-
原文地址:https://www.cnblogs.com/lykbk/p/dfedfefe2343434343.html
Copyright © 2020-2023
润新知