SQLCMD -S LPS-CENTRAL-DB\MSSQL_SERVER2012 -d NorthWind -Q "SELECT * FROM Employees" -s "," -o "D:\Yourfilename.csv"
Create CSV File From Comand Prompt
This code snippet is for Create CSV File From Comand Prompt.
Loading
This code snippet is for Create CSV File From Comand Prompt.
SQLCMD -S LPS-CENTRAL-DB\MSSQL_SERVER2012 -d NorthWind -Q "SELECT * FROM Employees" -s "," -o "D:\Yourfilename.csv"