maximum number of parameters in sql query

The limits are hard-coded:

• Parameters per stored procedure 2,100
• Parameters per user-defined function 2,100

I wrote some code before that split the Contains query into batches and combined the results… see here for more.