sys.sp_get_query_template

Description

Returns the parameterized form of a query. The results returned mimic the parameterized form of a query that results from using forced parameterization. The query for which the parameterized version is to be generated.

Syntax

sp_get_query_template

Examples

Example 1

sp_get_query_template

Example 2

NULL

Example 3

sp_get_query_template

Example 4

USE
AdventureWorks2022;
GO
DECLARE
@my_templatetext
AS
NVARCHAR (
MAX
);
DECLARE
@my_parameters
AS
NVARCHAR (
MAX
);
EXECUTE sp_get_query_template N
'SELECT pi.ProductID, SUM(pi.Quantity) AS Total
FROM Production.ProductModel pm
INNER JOIN Production.ProductInventory pi
ON pm.ProductModelID = pi.ProductID
WHERE pi.ProductID = 2
GROUP BY pi.ProductID, pi.Quantity
HAVING SUM(pi.Quantity) > 400'
,
@my_templatetext
OUTPUT
,
@my_parameters
OUTPUT
;
SELECT
@my_templatetext;
SELECT
@my_parameters;