sqlserverBulkInsert命令详细

BULK INSERT以用户指定的格式复制一个数据文件至数据库表或视图中。
语法：

BULK INSERT [ [ 'database_name'.][ 'owner' ].]{ 'table_name' FROM 'data_file' } 
WITH (
  [ BATCHSIZE [ = batch_size ] ], 
  [ CHECK_CONSTRAINTS ],  
  [ CODEPAGE [ = 'ACP' | 'OEM' | 'RAW' | 'code_page' ] ],
  [ DATAFILETYPE [ = 'char' | 'native'| 'widechar' | 'widenative' ] ],   
  [ FIELDTERMINATOR [ = 'field_terminator' ] ],
  [ FIRSTROW [ = first_row ] ],
  [ FIRE_TRIGGERS ],
  [ FORMATFILE = 'format_file_path' ],
  [ KEEPIDENTITY ],
  [ KEEPNULLS ],
  [ KILOBYTES_PER_BATCH [ = kilobytes_per_batch ] ], 
  [ LASTROW [ = last_row ] ],
  [ MAXERRORS [ = max_errors ] ],
  [ ORDER ( { column [ ASC | DESC ] } [ ,...n ] ) ], 
  [ ROWS_PER_BATCH [ = rows_per_batch ] ],
  [ ROWTERMINATOR [ = 'row_terminator' ] ],   
  [ TABLOCK ],
)
 

查看更多关于sqlserverBulkInsert命令详细的详细内容...