How to assign the result of READTEXT to a variable?

30 Jun 2006 3:06 AM

Jun Yuan

Hi, is there a way to store the result of READTEXT function to a variable?
Thanks

30 Jun 2006 3:58 AM

Aaron Bertrand [SQL Server MVP]

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...

Show quote

"Jun Yuan" <JunY***@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

30 Jun 2006 6:51 AM

Jun Yuan

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).

Show quote

"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" <JunY***@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
>
>
>