Post reply

How to use Text data type in sqlserver 2000

  • June 10, 2008 at 3:15 am

    #183324

    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 3:53 am

    #826505

    hi,

    can it work with varchar(7999)

    declare @test-2 varchar(7999)

    is ur @test-2 variable store more than 8000 character?

    regards,

    vijay

  • June 10, 2008 at 4:39 am

    #826525

    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

    #826542

    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