Description:-
Social media is evolving at a
rapid pace and every day I keep on getting question from different methods.
Here is the latest question which I received on my Facebook page. The question was
how to export the data of query into CSV using SQLCMD.
Generically you can use the following syntax:
SQLCMD -S
YourSQLServer -d YourDatabase -U YourUserName -P YourPassword -Q "Your Query"
-s "," -o "C:\Yourfilename.csv"
Thanks for comments.....