June 10, 2008 at 3:15 am
Hi,
Good afternoon
I am using Text Data type in sql server 2000 as shown below,
eg:-
DECLARE @test-2 TEXT
then at the time of execution it throwing an error message is like this
The text, ntext, and image data types are invalid for local variables.
I required the exact sysntax how to use TEXT data type in sql server 2000?
plz herp out to achive this...
June 10, 2008 at 4:39 am
Thank U Vijay,
but my requirement is to store more than 8000 charchater,
vrachar max vcalue is 8000
i.e so that reason ,i have taken TEXT data type,
i want how to use TEXT data type ????
Regds,
rclgoriparthi.
June 10, 2008 at 5:27 am
You cannot use a TEXT data type for a variable. Why do you need it in a variable? What are you trying to do? With what you have provided for information, all we can tell you is that it cannot be done. If you provide a bit more information, there is likely a way to do woat you want that does not involve a variable of a blob data type.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply