Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Location
    Malaysia
    Posts
    17

    Smile Unanswered: regarding stored procedures.....

    i need to declare a local variable in SQL stored procedure.
    this variable should have data type with no specific length. i mean like 'text','ntext'.

    i am trying to declare 'text' datatype for this local variable. but i got an error mesage saying that "text,ntext,image datatypes cannot be used for local variable."

    can u pls help me wheather there is any other data type that can be declared as local variables.

    with regards

    varma.
    --------------------
    P.L.N.Prasad varma

  2. #2
    Join Date
    Jul 2004
    Posts
    69
    are you sure you wanna declare a variable with no specific length? well anyways, there's the datatype varchar or char...maybe it'll help solve your prob. but regarding no definite length...why not use the default parameter? just @?

  3. #3
    Join Date
    Feb 2004
    Posts
    6
    text/ntext can be passed as an argument, but not declared as a local variable.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •