Showing posts with label readtext. Show all posts
Showing posts with label readtext. Show all posts

Wednesday, March 28, 2012

How to assign the result of READTEXT to a variable?

Hi, is there a way to store the result of READTEXT function to a variable?
ThanksYou can't, because you can't have a local variable using TEXT or NTEXT
datatypes.
Maybe you could explain exactly what you are trying to do, instead of how
you think you need to solve it...
"Jun Yuan" <JunYuan@.discussions.microsoft.com> wrote in message
news:B875ECBA-F888-47F9-A8E8-C81D182815B9@.microsoft.com...
> Hi, is there a way to store the result of READTEXT function to a variable?
> Thanks|||Thans for you reply.
I encounter a field with image datatype. A series of HEX data are saved in
this field. Every four bytes represent a single number. (Single is a data
type in VB). I want to handle every four bytes one by one.
Although I can't define a local variable using TEXT or NTEXT, I could define
a variable using VARBINARY(4). But there is no way to store the result of
READTEXT into a variable of VARBINARY(4).
"Aaron Bertrand [SQL Server MVP]" wrote:

> You can't, because you can't have a local variable using TEXT or NTEXT
> datatypes.
> Maybe you could explain exactly what you are trying to do, instead of how
> you think you need to solve it...
>
> "Jun Yuan" <JunYuan@.discussions.microsoft.com> wrote in message
> news:B875ECBA-F888-47F9-A8E8-C81D182815B9@.microsoft.com...
>
>sql

Sunday, February 19, 2012

How to access Sql TEXTPTR from a page

Hello everyone,

I have a stored procedure which returns a txtptr to ntext data (resulted from READTEXT operation) and its datatype is varbinary(16). In my web page, I want to get the text read and display it using a mutiline textbox. Does anyone know how to access that ntext data ?

Thank you very much.

Regards,

Billy.Just return the TEXT field via a DataReader instead of returning the txtptr.|||Thanks for your reply Darrell.