想重A DB 取全部0R部分 新增到 B DB內，找了一些相關資料關於批次搬移資料的方式，其中我選擇
BULK INSERT(依照使用者指定的格式，將資料檔匯入資料庫資料表或檢視表中。)，語法如下：
1: BULK INSERT
2: [ database_name . [ schema_name ] . | schema_name . ] [ table_name | view_name ]
3: FROM 'data_file' 4: [
WITH 5: (
6: [ [ , ] BATCHSIZE = batch_size ]
7: [ [ , ] CHECK_CONSTRAINTS ]
8: [ [ , ] CODEPAGE = {
'ACP' |
'OEM' |
'RAW' |
'code_page' } ]
9: [ [ , ] DATAFILETYPE =
10: {
'char' |
'native'|
'widechar' |
'widenative' } ]
11: [ [ , ] FIELDTERMINATOR =
'field_terminator' ]
12: [ [ , ] FIRSTROW = first_row ]
13: [ [ , ] FIRE_TRIGGERS ]
14: [ [ , ] FORMATFILE =
'format_file_path' ]
15: [ [ , ] KEEPIDENTITY ]
16: [ [ , ] KEEPNULLS ]
17: [ [ , ] KILOBYTES_PER_BATCH = kilobytes_per_batch ]
18: [ [ , ] LASTROW = last_row ]
19: [ [ , ] MAXERRORS = max_errors ]
20: [ [ , ]
ORDER ( {
column [
ASC |
DESC ] } [ ,...n ] ) ]
21: [ [ , ] ROWS_PER_BATCH = rows_per_batch ]
22: [ [ , ] ROWTERMINATOR =
'row_terminator' ]
23: [ [ , ] TABLOCK ]
24: [ [ , ] ERRORFILE =
'file_name' ]
.gif)