--导入

INSERT INTO [netmonsdb].[dbo].[keywordlist]([keyword])

SELECT * FROM OPENROWSET(

    BULK 'D:/xmsys/dd/dd.txt',

    FORMATFILE='d:/BCPFORMAT.xml'

    --,    FIRSTROW=2

) AS T;

<?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="\r\n" />

  </RECORD>

  <ROW>

    <COLUMN SOURCE="1" NAME="keyword" xsi:type="SQLVARYCHAR"/>

  </ROW>

</BCPFORMAT>