Results 1 to 2 of 2
  1. #1
    Join Date
    May 2002

    Unanswered: Supressing Column Headings

    When using isqlw (or Query Analyzer for that matter) to run a query on a SQL Server7 database is it possible to suppress the column headings. (As in Oracle's SET HEADING OFF).

    Also with isqlw, if i specify the username on the command line with -U is it possible to get it to prompt for the password?

  2. #2
    Join Date
    Feb 2002
    Houston, TX
    Both ISQL & OSQL support a "No headers" switch. -h-1 will return results without headers. Read the notes in BOL.

    If you use the -U switch without the -P switch both ISQL & OSQL will will prompt you for a password.
    Paul Young
    (Knowledge is power! Get some!)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts