bcp "select AcNo,convert(varchar(10),OpenDate,120) as OpenDate,AcName From TSK" queryout d:\today.txt -c -t
, -Usa -Psa
该语句输出到文本的内容以逗号分割开,如:
acno1,2007-01-11,acname1
acno2,2007-01-11,acname2
........
但是我希望输出的数据除了逗号分割外,还用双引号括起没个值,如下:
"acno1","2007-01-11","acname1"
"acno2","2007-01-11","acname2"
........
因为很多时候
AcName的内容带有逗号
|