Export (0) Print
Expand All

Replace Template Parameters

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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.

The Specify Values for Template Parameters dialog is a grid with three columns. The Parameter and Type columns are read-only and cannot 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>.

After opening the template in a code editor window:

  1. On the Query menu, click Specify Values for Template Parameters.

  2. 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.

  3. Click OK to close the Replace Template Parameters dialog box and modify the script in the query editor.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft