I've just started writing a Stored Procedure in SQL Server 2008 and have 30+ parameters. I've never written one with more than ~10 parameters, and that got me thinking... At what point are there too many parameters?
For context... This procedure will essentially INSERT a single row into a single Table. There would also be a very similar; albeit somewhat smaller; version that performs an UPDATE on the same table. Most fields are relatively small with a mix of int and strings (varchar(200)).
What are the issues; good or bad; to having a procedure with a large number of parameters and what is the threshold where I should start considering other patterns?