SQL Server Performance

Remove the lines '----' from the query output

Discussion in 'General Developer Questions' started by ssivaprasad, Jun 6, 2006.

  1. ssivaprasad New Member

    On TSQL Command of;

    set nocount on
    select @@version

    Getting the output as;

    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
    May 3 2005 23:18:38
    Copyright (c) 1988-2003 Microsoft Corporation
    Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)


    How to remove the lines "-------" from the output?





    ------------------
    S SIVAPRASAD
    #2970;#3007; #2970;#3007;#2997;#2986;#3007;#2992;#2970;#3006;#2980;#3021;
    ssivaprasad, Jun 6, 2006
    #2

  2. spacemonkey New Member

    Are you doing this in Query Analyzer? If you are showing results in text, there will be the ----- at the top. If you set it to results in grid, it will not show that since the ---- is not really part of the @@version output.

    John
    spacemonkey, Jun 6, 2006
    #2

  3. thomas New Member

    In QA Text Output, Tools.. Options.. Results tab unselect "Print Column Headers", this removes those lines.
    thomas, Jun 6, 2006
    #2

  4. FrankKalis Moderator

    FrankKalis, Jun 6, 2006
    #2

  5. Madhivanan Moderator

    In QA, press Ctrl+D to switch to results in Grid

    Madhivanan

    Failing to plan is Planning to fail
    Madhivanan, Jun 6, 2006
    #2

  6. sivaraman New Member

    Uncheck the "Include the Column headers in Result" in Query Option

    sivaraman, Jun 7, 2006
    #2

  7. Adriaan New Member

    The silly response would be: select the line of hyphens, and delete them. But I probably shouldn't be posting silly responses.
    Adriaan, Jun 7, 2006
    #2

  8. ssivaprasad New Member

    Here is the sample query and output.

    Please note the query I am passing would vary. Tell me how can I get the output without the lines.

    Note: Please avoid silly responses like CTRL+D, Uncheck Column Headers.
    Also I do not want to do the Find/Replace sort of processing result set again.

    D:Documents and SettingsSRVRt>osql -E -Sw2SRVRt01 -Q"set nocount on select @@version"

    -------------------------------------------------------------------------------
    -------------------------------------------------------------------------------
    --------------------------------------------------------------------------------
    --------------------------------------------------------------

    Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
    May 3 2005 23:18:38
    Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on Windows
    NT 5.1 (Build 2600: Service Pack 2)

    ------------------
    S SIVAPRASAD
    #2970;#3007; #2970;#3007;#2997;#2986;#3007;#2992;#2970;#3006;#2980;#3021;
    ssivaprasad, Jun 7, 2006
    #2

  9. Adriaan New Member

    You didn't mention you were using the OSQL tool, so how were we to know that you're not working in Query Analyzer?[<img src='/community/emoticons/emotion-5.gif' alt=';)' />]
    Adriaan, Jun 7, 2006
    #2

  10. FrankKalis Moderator

    A quite important fact that you're using OSQL, that you've missed to mention in your original post, don't you think? [<img src='/community/emoticons/emotion-5.gif' alt=';)' />]<br />The answers can only be as good as the question is. So please avoid notes like this:<br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><br /> Note: Please avoid silly responses like CTRL+D, Uncheck Column Headers.<br />Also I do not want to do the Find/Replace sort of processing result set again.<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><br />Before getting into another misunderstanding, can you please tell us, what you want to do with the result and why *exactly* you want this without the column headers?<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a>
    FrankKalis, Jun 7, 2006
    #2

  11. thomas New Member

    Note: Please avoid silly posts that don't give all the required information in the first place.
    thomas, Jun 19, 2006
    #2

  12. cmdr_skywalker New Member

    If you are using it in a OS Batch command, try using the PRINT instead.

    DECLARE
    @Data VARCHAR(8000)

    SELECT @Data = @@VERSION
    PRINT LEFT(@Data, DATALENGTH(@Data))
    -- instead of SELECT

    May the Almighty God bless us all!
    www.empoweredinformation.com
    cmdr_skywalker, Jun 19, 2006
    #2

  13. satya Moderator

    Are you storing the result for any reports to management?

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided �AS IS� with no rights for the sake of knowledge sharing.
    satya, Jun 19, 2006
    #2

  14. balaganesh2k Member

    If you are using OSQL then how will be your result set.
    I think that will be in some file. then you need to do play around that file to get all information right.


    Ganesan B.
    Well defined problem is half way solved.
    balaganesh2k, Jun 21, 2006
    #2

Share This Page