We need to stop using Stored Procedures

Automated excerpt

Please, application developer, I beg you, learn some SQL! Conveniently, parameterized queries also help us reuse query plans from the plan cache. Leading in from above, if your query has a varying number of parameters in the predicate, e. g. : Each query with N parameters will be a different query plan, TVPs can help you reuse the same query plan regardless of the number of parameters.

Selected automatically from source text; not independently written or fact-checked. Read the original for full context.