Categories: MSDN / DotNet / Java / Scripts / Linux / PHP Ask - La ask - La Answer

THE maximum number of parameter that can be pass to sql statement

hi,
my programming language is delphi 6,
My database is access 2000, I want to know the maximum number of parameters
that can be pass to SQL statement
Do any one can guide me in this issue or any link that describe it for me?
thanks in advance
hamid reza
[293 byte] By [hamid reza] at [2007-11-9 21:11:13]
# 1 Re: THE maximum number of parameter that can be pass to sql statement
a stored procedure can have a maximum of 2,100 parameters.

bye

"hamid reza" <hra57@hotmail.com> wrote:
>
>hi,
>my programming language is delphi 6,
>My database is access 2000, I want to know the maximum number of parameters
>that can be pass to SQL statement
>
>Do any one can guide me in this issue or any link that describe it for me?
>
>thanks in advance
>
>hamid reza
>
Joao Batista Nunes Junior at 2007-11-11 23:51:19 >