Post reply

maximum input parameters for stored procedure

  • May 2, 2003 at 7:26 am

    #82164

    What is the number of maximum input parameters for stored procedure in SQL Server 2000?

  • May 2, 2003 at 9:03 am

    #456010

    According to BOL (look under 'limitations-SQL Server objects'), the maximum no of parameters is 2100.

    It doesn't specify whether there is a specific limit on input vs output parameters.

    Not sure if there is a limit

  • May 2, 2003 at 9:12 am

    #456016

    SQL 7 is 1024

    SQL 2K is 2100

    Found under Create Procdure in BOL for property of n argument.

    All can be Input or Output.

    Edited by - antares686 on 05/02/2003 09:12:26 AM

  • May 2, 2003 at 9:34 am

    #456019

    Thanks both.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply