关闭

bcp

257人阅读 评论(0) 收藏 举报

BCP 语法:

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]"]
 

常用法:

EXEC master.dbo.xp_cmdshell 'BCP test04.dbo.t1 out "d:/as.txt" -c -S localhost -U sa -P 4saadmin'

0
0

查看评论
* 以上用户言论只代表其个人观点,不代表CSDN网站的观点或立场
    个人资料
    • 访问:37915次
    • 积分:652
    • 等级:
    • 排名:千里之外
    • 原创:18篇
    • 转载:66篇
    • 译文:0篇
    • 评论:0条
    文章分类