Create CSV File From Comand Prompt

  1. SQLCMD -S LPS-CENTRAL-DB\MSSQL_SERVER2012 -d NorthWind -Q "SELECT * FROM Employees" -s "," -o "D:\Yourfilename.csv"