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.

本文地址：http://www.bzuk.cn/news/27e5099922.html