These pages cover SQL Prompt 7, which is not the latest version. Help for other versions is also available.

Skip to end of metadata
Go to start of metadata

You can specify SQL Server Management Studio template parameters in SQL Prompt snippets.

Example: Creating and inserting a snippet with template parameters

In this example, we will create a snippet to select the following from a table:

  • the top N rows
  • a title displaying the total number of rows

To create the snippet:

  1. On the SQL Prompt menu, select Snippet Manager.
  2. Click New.
  3. In the Snippet box, type the text that will insert the snippet.
    In this example, we type stn:

  4. Type or paste SQL code that includes template parameters in the Code box.
    You specify template parameters using the format <parameter_name, data_type, value>. For more information, see Using SQL Server Management Studio Templates (Microsoft documentation).
    In this example, we use the following snippet code:

  5. Click Save.

We can now insert the snippet into a query, and replace the template parameters with the values we want to use:

  1. In a query window, type stn, and then press Tab.
    The snippet is inserted into the query, and the Specify Values for Template Parameters dialog box opens:
  2. Specify the values you want to use, and click OK.
  • No labels