Note
Access to this page requires authorization. You can try signing in or .
Access to this page requires authorization. You can try .
Replace template parameters
Applies to: 👁 Image
SQL Server 👁 Image
Azure SQL Database 👁 Image
Azure SQL Managed Instance 👁 Image
Azure Synapse Analytics 👁 Image
Analytics Platform System (PDW)
Templates contain parameters that can be replaced by implementation-specific values each time the template is used. After opening a template in a code editor, you can replace the parameters with values relevant to your implementation.
Before you begin
The Specify Values for Template Parameters dialog is a grid with three columns. The Parameter and Type columns are read-only and can't be changed. Review the contents of the Value column, and change any of the defaults to values appropriate for your implementation.
To use this dialog box, you must have parameters in your script enclosed in angle brackets (< >) in the format <parameter_name, data_type, default_value>.
Replace query template parameters
After opening the template in a code editor window:
On the Query menu, select Specify Values for Template Parameters.
In the Specify Values for Template Parameters dialog box, the Values column contains a suggested value for each parameter. Accept the value or replace it with a new value.
Select OK to close the Specify Values for Template Parameters dialog box and modify the script in the query editor.
Related content
Feedback
Was this page helpful?