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
Showing posts with label readtext. Show all posts
Showing posts with label readtext. Show all posts
Wednesday, March 28, 2012
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.
Subscribe to:
Posts (Atom)