Exporting Query Results to CSV using SQLCMD

Here, I am going to explain exporting the query result to CSV using SQLCMD in SQL Server.

This is a very easy process and a very simple command to export query data. Syntax of this command is as shown below-
  

Syntax-  
SQLCMD -S SQLServerName -d DatabaseName -U UserName -P Password -Q “SQL Query” -s “,” -o “C:\FileName.csv”

For example, I have following select query which I will export to CSV file. 

Select SubID, SubCode, SubName

from Subjects

The above query will return the following result-

Now we can export the above result set data to CSV using SQLCMD using following command-

SQLCMD -S Nayab\SQL2008R2 -d TestDatabase -U Pcare -P Che
tu@123 -Q "Select SubID, SubCode, SubName from Subjects" -s "," -o "D:\Test1.csv"

Now you can go to your file location and you will find the new created CSV file there. When you open the CSV file you will get the result of the query.