January 8, 2008 at 2:10 am
I have a table with a resume column of datatype text.
I need to perform a select operation on this table so as to read the resumes of certain people.
The value of this column is displayed as 'LongText'
What conversion should I do? What function should I use to read text?
I know of the ReadText statement.. Kindly let me know how exactly I should use this.
January 8, 2008 at 2:28 am
see SQL BOL for more information as well as example.
January 8, 2008 at 2:53 am
I did read it.. but when I use the exact same query on my db, it only says -so n so- number of rows affected. Doesn't show me anything though!
January 8, 2008 at 3:05 am
What client side tools are you using? Usually you can just select the column like any other.
January 8, 2008 at 3:18 am
I'm querying a remote database (at a different office site of the world) from Query Analyzer (SQL 2k).
January 8, 2008 at 4:23 am
If I was to create a table with a column of datatype text and insert it with records through Management Studio or Query Analyzer, it would allow me to do so.
Also, if i perform a select operation on this particular table, I can read the text data.
However, with the Resume column in my remote db, I have no clue how the records have been inserted as the fields apparently only store pointers to the data pages containing the actually text data.
In this case, why can I not view the actual text data with a select operation?
Like I said, I also used the TEXTPTR function to obtain the pointer to that column and then used the READTEXT feature to be able to view the data.
Unfortunately, no luck on this.
What other options do I have?
January 8, 2008 at 7:26 am
It will only show some pointer information in the Grid mode... you must be in the Text mode to see the data from a Text datatype.
Best thing to do would be to copy it into a new table VARCHAR(MAX).
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply