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 2000 Forums
 SQL Server Development (2000)
 no columns reported

Author  Topic 

edpel
Starting Member

22 Posts

Posted - 2002-12-13 : 14:10:58
I need to run a script and just have the data reported, not the column headers. I will be running this script through isql so I can't change the settings in query analyzer, is their a command I can run in the script to turn column headers off?

Thanks,
Eddie

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2002-12-13 : 14:31:19
isql will accept command line parameters. A quick check of Books Online shows the option to get rid of column headers is:

-h-1

It's case sensitive and you can't have a space between the -h and -1.

===============================================
Creating tomorrow's legacy systems today.
One crisis at a time.
Go to Top of Page
   

- Advertisement -