当前位置: 当前位置:首页 >域名 >BULK INSERT如何将大量数据高效地导入SQL Server 正文

BULK INSERT如何将大量数据高效地导入SQL Server

2025-11-04 14:16:33 来源:多维IT资讯作者:人工智能 点击:538次
BULK INSERT如何将大量数据高效地导入SQL Server
复制<?大量地导xmlversionxmlversion="1.0"?> <BCPFORMAT xmlns="http://schemas.microsoft.com/sqlserver/2004/bulkload/format" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <RECORD> <FIELDIDFIELDID="1"xsi:type="CharTerm"TERMINATOR=","/> <FIELDIDFIELDID="2"xsi:type="CharTerm"TERMINATOR=","/> <FIELDIDFIELDID="3"xsi:type="CharTerm"TERMINATOR=","/> <FIELDIDFIELDID="4"xsi:type="CharTerm"TERMINATOR=","/> <FIELDIDFIELDID="5"xsi:type="CharTerm"TERMINATOR=","/> <FIELDIDFIELDID="6"xsi:type="CharTerm"TERMINATOR=","/> <FIELDIDFIELDID="7"xsi:type="CharTerm"TERMINATOR="\r\n"/> </RECORD> <ROW> <COLUMNSOURCECOLUMNSOURCE="1"NAME="Date"xsi:type="SQLDATE"/> <COLUMNSOURCECOLUMNSOURCE="2"NAME="OpenPrice"xsi:type="SQLDECIMAL"PRECISION="6"SCALE="2"/> <COLUMNSOURCECOLUMNSOURCE="3"NAME="HighPrice"xsi:type="SQLDECIMAL"PRECISION="6"SCALE="2"/> <COLUMNSOURCECOLUMNSOURCE="4"NAME="LowPrice"xsi:type="SQLDECIMAL"PRECISION="6"SCALE="2"/> <COLUMNSOURCECOLUMNSOURCE="5"NAME="ClosePrice"xsi:type="SQLDECIMAL"PRECISION="6"SCALE="2"/> <COLUMNSOURCECOLUMNSOURCE="6"NAME="Volumn"xsi:type="SQLINT"/> </ROW> </BCPFORMAT> 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.29.30.31.32.33.34.35.36.37.38.39.40.41.42.43.
作者:数据库
------分隔线----------------------------
头条新闻
图片新闻
新闻排行榜