For this reason, SQL Server stores execution plans in ... developers took to avoid this problem in the past: using nested stored procedures based on the value of the input parameter, except ...

You can use full, inline SQL statements in the prepared statement function or send the database a stored procedure function. A stored procedure is a program that is stored on the database server.