Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Maximum number of SP parameters?
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Versions des environnements
SQL Server:
SQL Server 2000
Divers
Thread ID:
01096204
Message ID:
01096215
Vues:
14
>>Is there a maximum number of parameters for a SP? If yes what is the maximum number? (I think I might have reached such number in one of my SP <s>)
>
>2,100. See Maximum Capacity Specifications in BOL.

Great then I am not exceeding it. I only have 303 parameters!. Thanks for the reply Sergey.

Update: I duplicated one of the parameters when I called the SP, but good to know that the max is 2100.

Einar
Semper ubi sub ubi.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform