Question: how to export data from sql server to csv file?
Answer: Right-click the table name in the object tree view., Select Export., Select CSV. The Export Data window shows up., Click Format tab., Select Format as: CSV., Enter a file name and location., Click Columns tab., Check the columns you wish to export.