Bulk Insert Sample

来源：互联网发布：科比公司知乎编辑：程序博客网时间：2024/05/14 18:32

create table userName(name nvarchar(50),id numeric(9,0) IDENTITY(1,1) not null,CONSTRAINT [PK_userName] PRIMARY KEY (id))BULK INSERT [logSystem]..[userName] FROM 'D:\BulkInsertTest\bulktest1.txt'  WITH( FORMATFILE='D:\BulkInsertTest\bulktest.xml', FIELDTERMINATOR=',',ROWTERMINATOR='\r\n')

<?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="30"/>  <FIELD ID="2" xsi:type="CharTerm" TERMINATOR="," MAX_LENGTH="30"/>  <FIELD ID="3" xsi:type="CharTerm" TERMINATOR="," MAX_LENGTH="30"/>  <FIELD ID="4" xsi:type="CharTerm" TERMINATOR="," MAX_LENGTH="30"/>  <FIELD ID="5" xsi:type="CharTerm" TERMINATOR="\r\n" MAX_LENGTH="12"/> </RECORD> <ROW>  <COLUMN SOURCE="5" NAME="name" xsi:type="SQLNVARCHAR"/> </ROW></BCPFORMAT>

554,0,sa,sb,sc554,0,sa,sb,sc554,0,sa,sb,sc554,0,sa,sb,sc554,0,sa,sb,sc554,0,sa,sb,sc554,0,sa,sb,sc554,0,sa,sb,sc554,0,sa,sb,sc

0 0