Home Forums SQL Server 2008 SQL Server 2008 - General How do we generate csv with custom data? RE: How do we generate csv with custom data?
sarath.tata
SSCommitted
Points: 1640
More actions
February 26, 2015 at 1:53 pm
#1780398
Right now, I have created SP and used sqlcmd to dump to file. But, when I open in text file, it shows up lots of empty space as it takes some width on each column like below.
"Text1" ,"Text2"
"ttt" ,"T"
I'm still not sure if this is the best way!!