如题,没大用过BCP,BCP调用过程,语句怎么写啊?谢谢,为我的无知祈祷把
这个问题第1个回答:
bcp {[[database_name.][owner].]{table_name | view_name} | "query "} {in | out | queryout | format} data_file [-m max_errors] [-f format_file] [-e err_file] [-F first_row] [-L last_row] [-b batch_size] [-n] [-c] [-w] [-N] [-V (60 | 65 | 70)] [-6] [-q] [-C code_page] [-t field_term] [-r row_term] [-i input_file] [-o output_file] [-a packet_size] [-S server_name[\instance_name]] [-U login_id] [-P password] [-T] [-v] [-R] [-k] [-E] [-h "hint [,...n] "]
这个问题第2个回答:
例子: bcp "Northwind.[Jane Doe].[Jane 's Orders] " out "Jane 's Orders.txt " -c -U "Jane Doe " -P "go dba "
这个问题第3个回答:
楼上的,你这例子中哪个是过程名啊?
这个问题第4个回答:
向存储过程传递常量时不能使用 OUTPUT 选项
|