by September 24, 2011on
Because I always forget how to export data from the SQLServer into a CSV 1 file I will post it up here:
EXEC master..xp_cmdshell'bcp "SELECT * FROM table" queryout "c:\tmp\export.txt" -c -T -x'
Find more useful tips concerning
T-SQL on inpad.de
Comma separated file↩