資料庫名稱：MS SQL
資料庫版本：2014
內容/問題描述：
create table user1
(id int, acct varchar(50), name varchar(50))
insert into user1
values (1, 'A001', '邱小姐')
, (2, 'A002', '呂小姐')
, (3, 'A003', '陳先生')
, (4, 'A004', '蔡先生')
, (5, 'A005', '黃先生')
想匯出每一行的每個字串都被""雙引號包住的csv
想要的結果是：
"1","A001","邱小姐"
"2","A002","呂小姐"
"3","A003","陳先生"
"4","A004","蔡先生"
"5","A005","黃先生"
使用bcp的方式
bcp "select * from dbo.user1" queryout "D:\user.csv" -t"\",\"" -r"\"\n\"" -S
192.168.0.1 -d UserDB -U sa -P password -w
但出來的結果是
1","A001","邱小姐"
"2","A002","呂小姐"
"3","A003","陳先生"
"4","A004","蔡先生"
"5","A005","黃先生"
"
差一點點，第一列的"不見了，好像跑去最後一列
請問我該怎麼調整最好呢？
非常感謝