Programming output to a .CSV file

[hne]

Hello,
I would like to know how can I program my MsSQL to send my output to a .CSV file? Thanks.

 

[nomadicalloy]

you can use stored proc with bcp command/format file to create csv file

code

Exec master..xp_cmdshell ''bcp "SELECT * FROM ##WrkData_LBW_Exp_2" queryout ' + CSV_FILE_Location + ' -f loanbase_format_2.fmt

Thanks

http://www.xpherion.com/blog.asp

 

[mrdenny]

You can use BCP, BulkInsert, or DTS to export data from MS SQL to a CSV file.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)