Journey of a Programmer

bcp or sqlcmd commands can be used to achieve this.

SQLCMD - With header:


All names in CAP need to be defined according to your environment /db.

sqlcmd -S SERVERNAME -d DATABASE_NAME -E -o "c:\EXPORTED_CSV_FILE.csv" -Q "select * from TABLENAME" -W -w 999 -s","

•  -W   remove trailing spaces from each individual field 
• -s","   sets the column seperator to the comma (,)
• -w 999   sets the row width to 999 chars

SQLCMD - Without header:

sqlcmd -S SERVERNAME -d DATABASE_NAME -E -o "c:\EXPORTED_CSV_FILE.csv" -Q "select * from TABLENAME" -W -w 999 -s"," -h-1

• -h-1 removes column name headers from the result 

bcp Command:

bcp "select * from DATABASE.SCHEMA.TABLE" queryout  "c:\EXPORTED_CSV_FILE.csv"  -c -t"," -r"\n" -S SERVERNAME -T

While running bat files, if any error occurs, it will vanishes without waiting for the user to review it.  To overcome this issue, we can make the bat file to wait for the user input to terminate the window like getch() is being used in C programming.

To do that,  add

set /p DUMMY=Hit ENTER to continue...

at end of the bat file.


Hello World.....