bcp

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'

阅读更多
版权声明:本文为博主原创文章,未经博主允许不得转载。 https://blog.csdn.net/worker_1983/article/details/1785043
上一篇javascript的提示输出
下一篇Professional C#2005 学习札记
想对作者说点什么? 我来说一句

没有更多推荐了,返回首页

关闭
关闭