Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 SQLCMD syntax query

Author  Topic 

bendertez
Yak Posting Veteran

94 Posts

Posted - 2007-09-19 : 04:48:00
Is it possible to get rid of the column headings completely when outputting a file within SQLCMD?

The file outputs OK but has the column headers at the top. I just want the data.

I've seen the -h command which seems to be the header switch, but what the argument with it?

Thanks

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-09-19 : 04:57:35
use -h option with -1 to suppress column headers


Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"
Go to Top of Page

bendertez
Yak Posting Veteran

94 Posts

Posted - 2007-09-19 : 05:31:16
Thanks Harsh

wasn't aware of the negative value.
Go to Top of Page
   

- Advertisement -