sql server Bulk 批量导入大量数据

最新推荐文章于 2023-11-27 10:02:17 发布

小步快跑-

最新推荐文章于 2023-11-27 10:02:17 发布

阅读量2.3k

点赞数

分类专栏： sql server 文章标签： sql server SQL SERVER SQL Server 导入大量数据 Bulk

本文为博主原创文章，未经博主允许不得转载。

本文链接：https://blog.csdn.net/chinaplan/article/details/8150189

版权

sql server 专栏收录该内容

27 篇文章 0 订阅

订阅专栏

INSERT INTO RV_DetailedData (Email,Url)	
SELECT 	* FROM  OPENROWSET
(BULK 'E:\ftp\Travis\成功or点击\点击人数.csv','') AS t1

INSERT INTO RV_DetailedData (Email,Url)	
SELECT 	* FROM  OPENROWSET
(BULK 'E:\ftp\Travis\成功or点击\点击人数.csv',FORMATFILE='E:\ftp\Travis\成功or点击\da.xml') AS t1

INSERT INTO RV_DetailedData (Email)	
SELECT 	* FROM  OPENROWSET
(BULK 'E:\ftp\Travis\成功or点击\成功.csv',FORMATFILE='E:\ftp\Travis\成功or点击\复件 da.xml') AS t1

<?xml version="1.0"?>
<BCPFORMAT xmlns="http://schemas.microsoft.com/sqlserver/2004/bulkload/format" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<RECORD>
<FIELD ID="1" xsi:type="CharTerm" TERMINATOR="," MAX_LENGTH="255" COLLATION="Chinese_PRC_CI_AS" />
<FIELD ID="2" xsi:type="CharTerm" TERMINATOR="\n" MAX_LENGTH="255" COLLATION="Chinese_PRC_CI_AS" />
</RECORD>
<ROW>
<COLUMN SOURCE="1" NAME="Email" xsi:type="SQLNVARCHAR" />
<COLUMN SOURCE="2" NAME="Url" xsi:type="SQLNVARCHAR" />
</ROW>
</BCPFORMAT>

<?xml version="1.0"?>
<BCPFORMAT xmlns="http://schemas.microsoft.com/sqlserver/2004/bulkload/format" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<RECORD>
<FIELD ID="1" xsi:type="CharTerm" TERMINATOR="\n" MAX_LENGTH="255" COLLATION="Chinese_PRC_CI_AS" />

</RECORD>
<ROW>
<COLUMN SOURCE="1" NAME="Email" xsi:type="SQLNVARCHAR" />

</ROW>
</BCPFORMAT>