October 26, 2004 at 7:07 am
Hi Guys,
I want to know what is the maximum size of a parameter that I can pass to a stored procedure.
eg...
I have a stored procedure to which i am passing a query as a parameter.
If the query length is small the procedure works fine and gives proper results.
If query length is big the procedure gives error....
I tried printing the passed query and only part of query is printed....
Any clues on the same?????
October 26, 2004 at 8:42 am
try varchar(8000), should you need more just pass more parameters and execute them as exec (@param1 + @param2 + @param3 + @param4 + ...)
HTH
* Noel
October 26, 2004 at 9:40 am
You can also pass in a TEXT parameter.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply