Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-01-15 : 08:06:39
|
John writes "I am having a little trouble using READTEXT. I have a table that contains both a text blob and several other fields. Here is the code that I am currently using to return the blob:
DECLARE @@ptrval varbinary(16)
SELECT @@ptrval = TEXTPTR(copy)
FROM headlines
WHERE headlines_id = 1
READTEXT headlines.copy @@ptrval 0 87
select url, catchphrase from headlines
I would also like to be able to return the other columns in the table at the same time. They are two Varchars.
It is a little confusing, especially since the documentation doesn't go into any detail.
Thanks in advance for the help.
-John" |
|
|
|
|
|
ReadText