Passing parameter of length more than 4000 in sql server 2000
-
i am using sql server 2000. i want to pass a string parameter to sp. my problem is when the length of parameter increase 4000 then i gives error. In 2005 sql server we can use nvarchar(MAX) but how we can increase the length in sql 2000
One person's data is another person's program. --J.Walia
-
i am using sql server 2000. i want to pass a string parameter to sp. my problem is when the length of parameter increase 4000 then i gives error. In 2005 sql server we can use nvarchar(MAX) but how we can increase the length in sql 2000
One person's data is another person's program. --J.Walia
probably by using a BLOB, I would think. One more reason not to use a version of SQL Server that's two versions out of date. this is, of course, not an ASP.NET question.
Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.