bulk into例子

CREATE TABLE myTestFormatFiles (
   Col1 smallint,
   Col2 nvarchar(50),
   Col3 nvarchar(50),
   Col4 nvarchar(50)
   );
  
 /*
 10,Field2,Field3,Field4
15,Field2,Field3,Field4
46,Field2,Field3,Field4
58,Field2,Field3,Field4
 */
 EXEC master..xp_cmdshell 'bcp test..myTestFormatFiles format nul -c -t, -x -f d:\myTestFormatFiles.Xml -T'
  
 bulk insert dbo.myTestFormatFiles
 from 'd:\mytest.txt'
 with (formatfile='d:\myTestFormatFiles.Xml')
 go
 select *
 from dbo.myTestFormatFiles
 

参考：
 http://msdn.microsoft.com/en-us/library/ms191479.aspx

 

http://technet.microsoft.com/zh-cn/magazine/ms178129.aspx