How to generate a csv file using select query in SQL

Possible Duplicate:
How to export data as CSV format from SQL Server using sqlcmd?

I want to generate CSV file using select query in SQL-server.

The code below is working correctly in mySQL:

select * into outfile 'd:/report.csv' fields terminated by ',' from tableName;

It generated the CSV file.

Does anybody know how can I create a CSV file using select query in SQL-server?