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:35 AM
Hi,
As per your requirement i tryed to check with SQL Server 2000, it gives message the identify that start with variable name is too long. Maximum length is 128.
Hence you cannot have a stored procedure variable with more than 128 character length
and it is not good practive to keep variable with such long length, avoid doing this.
Regards,
>>Munnamax