December 3, 2004 at 6:56 am
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
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.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
December 3, 2004 at 1:21 pm
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
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
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
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