Question: how to export data from sql server to csv file using sqlcmd?
Answer: SQLCMD –S <<ServerName>> –E –Q "EXEC AdventureWorks2008R2.dbo.uspExport" ...  SELECT TOP 5 BusinessEntityID, 1,Chief Executive Officer ,M, 1963-03-02. ...  bcp "EXEC AdventureWorks2008R2.dbo.uspExport" queryout "C:\DataBCP.csv" –c –t , –S (local) –T.