Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2003
    Posts
    102

    Unanswered: Hiding the Title Output ?

    is there a way to suppress the output of the title of each column ?

    i.e.

    if that query would normally return


    Name | Age | Rank
    John 12 Lt
    Paul 11 Cpt
    George 10 Sgt
    Ringo 6 Prt



    Can i get it to return just:


    John 12 Lt
    Paul 11 Cpt
    George 10 Sgt
    Ringo 6 Prt

  2. #2
    Join Date
    Sep 2003
    Posts
    212
    where ru runing this script? in QA?

  3. #3
    Join Date
    Jan 2003
    Location
    India
    Posts
    523

    Re: Hiding the Title Output ?

    yes you can
    select name as ' ' ,age as ' ',rank as ' ' from table_name




    Originally posted by ontheDB
    is there a way to suppress the output of the title of each column ?

    i.e.

    if that query would normally return


    Name | Age | Rank
    John 12 Lt
    Paul 11 Cpt
    George 10 Sgt
    Ringo 6 Prt



    Can i get it to return just:


    John 12 Lt
    Paul 11 Cpt
    George 10 Sgt
    Ringo 6 Prt

  4. #4
    Join Date
    Sep 2003
    Posts
    522
    actually the proposed query will return this:

    | | |
    John 12 Lt
    Paul 11 Cpt
    George 10 Sgt
    Ringo 6 Prt

    this means that the heading will not be suppressed, but rather renamed to empty strings.

    in order to suppress the headings uncheck Print Column Headers in Tools/Options/Results of your query analyzer.

  5. #5
    Join Date
    Sep 2003
    Posts
    212
    Originally posted by ms_sql_dba
    actually the proposed query will return this:

    | | |
    John 12 Lt
    Paul 11 Cpt
    George 10 Sgt
    Ringo 6 Prt

    this means that the heading will not be suppressed, but rather renamed to empty strings.

    in order to suppress the headings uncheck Print Column Headers in Tools/Options/Results of your query analyzer.
    This question is related to the reply, is it possible to "uncheck Print Column Headers" with actually going to Tools>Options>Results? Is there is a script that would do that same? For example in Oracle you can say:

    Set Headings off

    Is this possible in Query Analyzer 2000?

Posting Permissions

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