You do this by creating a TEMPLATE plan guide on the parameterized form of the query, and specifying the PARAMETERIZATION FORCED query hint in the sp_create_plan_guide stored procedure.

• 可以通过在查询的参数化表单上创建TEMPLATE计划指南并在sp_create_plan_guide存储过程中指定PARAMETERIZATION FORCED查询提示来完成此操作。