How to suppress hyphens in SQLCMD

sql-server, sqlcmd

Solution

I don't think there's any option available to achieve this - you'll have to live with those headers, I'm afraid.

Problem

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> ```

Original source