hi this is kavita
I
am create a procedure with one input parameter bydefaut parameter lemth
is maximum 128 character in sql2000. is there any way to increase
parameter lenth?
thanks
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Munir ShaikhPosted Aug 7, 2007, 5:52 AM
Hi,
I had checked with microsoft SQL server 2000 variable length allows only 128 characters, there is no other way that you can have length more than 128 characters. It is not good practice to have long variable name do avoid such coding practice.
Regards,
>>Munnamax