The number depends on the database type and SQL server version. The optimal maximum is 64 parameters.