Using SQL Server Management Studio (SSMS)

Tools >> Options >> Query Results >> SQL Server >> Results to Text >> Output format

Drop down: Comma delimited

UNCHECK "Include Column headers in the result set" option.

Click "OK" Button.