Post reply

text, ntext, image datatypes in a stored proc

  • July 1, 2002 at 7:54 am

    #158601

    I am doing a stored procedure in which I am passing text parameters in. I am getting the following error message.

    "The text, ntext, and image data types are invalid for local variables."

    How do I work around this without changing the datatype? Is that even possible?

    Thanks for the help.

  • July 1, 2002 at 8:13 am

    #431910

    No dear Friend thats no t allowed in ms sql server 2000. Post some details regarding the purpose you want to use these datatypes...

    May be i can help...

    naveen mehta

  • July 1, 2002 at 9:33 am

    #431918

    I am using the columns to store comments with regards to incoming service calls. I guess I can set the columns to varchar(8000). Do you think this id the appropriate solution? Do you have any idea what this is not allowed? Seems strange to me.

    Thanks

  • July 1, 2002 at 9:36 am

    #431920

    Can you post a sample of the code?

    K. Brian Kelley

    bkelley@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/bkelley/

    K. Brian Kelley
    @kbriankelley

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply