Post reply

Turn of Result Column Headings in script

  • January 13, 2005 at 10:46 am

    #74840

    I am reading a Text column using READTEXT.

    READTEXT pas_template.template @ptr 0 @prtlen

    I get the data just fine.  I also get the column name and the separator line. I don't want them.

    I need get the text data without the column heading and separator line. 

    I need to do this in the script, not in the Query Analyzer menu options.

    Any suggestions would be appreciated.  Thanks.

    Jim

     

     

  • January 17, 2005 at 8:00 am

    This was removed by the editor as SPAM

  • January 17, 2005 at 8:53 am

    #537685

    How are you reading the data?

    What is your front-end?

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • January 17, 2005 at 9:05 am

    #537686

    I  am using MSSQL Server 2000 Query Analyzer and T-SQL scripts.

    I was reading the data in a T-SQL script. I was trying to use a T-SQL script to built another T-SQL script.

    I have since found that the Query Analyzer result pane maximum (8192) was being exceeeded by data in the text field, which truncated the data.

    So I wrote s simple vb.net program to read the text data and construct the T-SQL script I needed. 

    Problem resolved, but question about column headings on a READTEXT still unanswered.

     

  • January 17, 2005 at 9:39 am

    #537692

    Jim,

    Are you, by chance, looking at your results in Query Analyzer?  And, returning at the results in text format, rather than grid format?

    Query Analyzer will show you the column name by default, and I don't know how to turn that off.  But, internally in SQL Server, the column name (and separator line) is not included in the results.

     

  • January 17, 2005 at 9:44 am

    #537695

    Please see the previous post. 

    Thanks.

    Jim

  • January 18, 2005 at 1:27 am

    #537785

    Dealing with BLOB data is a royal pain at time when you only use SQL Server's built-in functionality. Just like you did, it is much better to do this in some client app with ADO. As for the READTEXT issue, I still am not sure what happens. Here's my standard link for BLOB and SQL Server. http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part3/c1161.mspx

    Maybe you'll find the answer there.

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • January 18, 2005 at 1:15 pm

    #537915

    Thanks,

    Jim

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply