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 store. Show all posts
Showing posts with label store. Show all posts
Wednesday, March 28, 2012
How to assign OR get Time value to a colum
How can i store time value in a column. And also i need to compare the values. Another problem is , how can i get the Current time of the server.(something like getdate() ?)
Happy Coding
hi,
there's no other function aside form getdate().
if you want it to be stored automatically to a column you have to enforce a "default constraint"
thanks,
joey
|||MasterG wrote:
How can i store time value in a column. And also i need to compare the values. Another problem is , how can i get the Current time of the server.(something like getdate() ?)
Happy Coding
Hi,
Please see answer; http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1000324&SiteID=1
Most people wont like you double posting a question here, but it looks like your new so I guess everyone will let you off, just the once
Happy Coding!
hth
Pace|||
What a shame but sorry for duplicate post. But it is caused from my web browser. Sorry for that , and also thanks for your solution.
Very Happy Coding now ha .....
Subscribe to:
Posts (Atom)