How to suppress hyphens in SQLCMD

Question

How can I suppress hyphens (------------) from the results set of this sqlcmd command:

C:\temp>sqlcmd -d AdventureWorks -s ";"   -Q "SET NOCOUNT ON SELECT top 5 FirstName, LastName FROM Person.Contact;" FirstName                                         ;LastName --------------------------------------------------;---------------------------- Gustavo                                           ;Achong Catherine                                         ;Abel Kim                                               ;Abercrombie Humberto                                          ;Acevedo Pilar                                             ;Ackerman  C:\temp> 

Answer 1

I didn't see all this info in once place and thought the next person looking for it might appreciate it...

use the -h -1 option to remove the dashes (--------) from the output and SET NOCOUNT ON to remove the "rows affected". This is great if you're creating a report or CSV file for another system to process.

Example:

SQLCMD -S 127.0.0.1\SQL_SERVER_Instance -d db_name -U db_login -P password -i your_script.sql -o your_output.csv -h -1 

In your SQL script:

SET NOCOUNT ON -- removes (rows affected from the output) select 'your_column_1, your_column_2' select * from your_table 

You don't need to use a union between your select statements for this.