Post reply

"QueryAnalyzer->Tools->Options->Results->Maximum characters per column:"

  • December 3, 2004 at 6:56 am

    #361702

    Hi. I have a table with ntext field in it. some of my texts have more than 8192 characters in it, but Query Analyzer does not let me display results longer than 8192 characters. I have tried using READTEXT but it still does not help.

    Does anyone know how to display text longer than 8192 characters.

    Thanks,

    Amira

  • December 3, 2004 at 7:38 am

    #532438

    You might have to write some ASP or VB code to get it to display. I suspect the textbox thing in QA is limited here for some reason.

  • December 3, 2004 at 1:21 pm

    #532537

    As Steve mentioned, you will need some other languages to retrieve long text because QA is not the right tool for that. If you just want to see part of data, you can use SUBSTRING to retrieve the block of data you are looking for.

  • December 3, 2004 at 2:03 pm

    #532543

    Hi,

    Did someone tried SQL Server Reporting Services? How much do they show? Amira may be able to use a commercial report tools in order not to use a front end language.

    There are some sample reports that come with Reporting Services, report files are XML documents that are basically editable in my favorite front end tool Visual Notepad (Notepad.exe), maybe try to modify those?

    Another possibility to use DTS to get the field into the text file

    Yelena

    Regards,Yelena Varsha

  • December 6, 2004 at 8:34 am

    #532679

    Thank you all. I have done it with Visual J#, but will try what Yelene told me because my employer want me to make it simple SQL Server stored procedure.

    Regards,

    Amira

  • December 7, 2004 at 6:02 am

    #532809

    Thanks Yelena, it worked as you said with reports as well.

    Thanks,

    Amira

Viewing 6 posts - 1 through 5 (of 5 total)

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