export csv using sql server SQL Server bcp (Bulk Copy Program)

 SQL Server bcp (Bulk Copy Program)

Command-line utility to export results to a CSV readable by Excel:

bcp "SELECT * FROM YourDatabase.dbo.YourTable" queryout "C:\output.csv" -c -t, -T -S localhost

-c: character mode

-t,: use comma as delimiter

-T: use Windows authentication

-S: specify server name

• Tweet
• Share
• Share
• Share
• Share

Sign up here with your email