1.txt
02288 2542216 陈琢 328
02288 2542252 孙自镛 330
02288 2542261 赖晓全 327
02288 2542289 胡蓓 216
02288 2542305 胡倩 216
02288 2542314 宋晓东 254
02288 2542323 吴莉萍 216
02288 2542341 燕群美 275
02288 2542350 赵春荣 282 如何把这些数据插到表 table_txt 里
02288 2542216 陈琢 328
02288 2542252 孙自镛 330
02288 2542261 赖晓全 327
02288 2542289 胡蓓 216
02288 2542305 胡倩 216
02288 2542314 宋晓东 254
02288 2542323 吴莉萍 216
02288 2542341 燕群美 275
02288 2542350 赵春荣 282 如何把这些数据插到表 table_txt 里
用streamreader一行行的读取,然后用空格分割开形成字符数组,用stringbuilder连接这些字符,就可以插入了
[ 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 ]
)
]