[数据库]Bulk Insert命令详细

Bulk Insert命令详细 

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 ],   
)  

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 ],  
) 

参数: 
'database_name'  
是包含指定表或视图的数据库的名称。如果未指定，则系统默认为当前数据库。 

'owner'  
是表或视图所有者的名称。当执行大容量复制操作的用户拥有指定的表或视图时，owner 是可选项。如果没有指定 owner 并且执行大容量复制操作的用户不拥有指定的表或视图，则 Microsoft® SQL Server? 将返回错误信息并取消大容量复制操作。 

'table_name'