Tutorial and example how to export to a comma separated file using sql server management studio (SSMS) and save as a CSV file from the grid or export using the wizard. We change to the pipe delimiter and demonstrate saving a query in SSMS as a CSV file.
https://www.dbtales.com