Sql Stored Procedure With a Lot of Parameters

Question

I am using Sql Server 2008. My Stored Procedure accepts almost 150 parameters. Is there anything wrong with that performance-wise?

Answer 1

when you are using SQL Server 2008 you can use the new Table parameter. If the parameters are the same, you can easily use the table parameter.

Here is link to the MSDN. Here is another link, a bit more explained

Enjoy.