| title | Query Parameters Dialog Box (Visual Database Tools) | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 06/13/2017 | ||
| ms.prod | sql-server-2014 | ||
| ms.reviewer | |||
| ms.technology | ssms | ||
| ms.topic | conceptual | ||
| f1_keywords |
|
||
| ms.assetid | 31cdaee2-d7cd-4d64-a45f-924b27e8b1f0 | ||
| author | stevestein | ||
| ms.author | sstein | ||
| manager | craigg |
This dialog allows you to enter values for the parameters defined in the query. This dialog box appears when you execute a query that contains parameters that require end-user input at run time.
Name
Lists the parameters defined for the query being executed. If the query contains named parameters, the names appear in the list. If the query contains unnamed parameters, system-defined parameter names are listed for each parameter in the query.
Value
Enter the value for each parameter listed under Name. The value used most recently appears as the default parameter value.
The following query in the SQL Pane, opens the Query Parameters dialog box when executed in the [!INCLUDEssSampleDBobject] database.
SELECT FirstName, LastName
FROM Person.Person AS Lastname
WHERE (LastName = @Param1);