Multiple choice technology databases

What's the maximum number of parameters can a SQL Server 2000 stored procedure have?

  1. 128

  2. 256

  3. 512

  4. 1,024

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

SQL Server 2000 stored procedures can have up to 1,024 parameters. This limit was increased from earlier versions. Options A, B, and C are too low. The 1,024 limit is a well-documented SQL Server 2000 specification.