| title | Create Queries with Unnamed Parameters (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 | ||
| helpviewer_keywords |
|
||
| ms.assetid | 5f4b664b-3d3d-4d07-a0e7-791d78743504 | ||
| author | stevestein | ||
| ms.author | sstein | ||
| manager | craigg |
You can create a query with an unnamed parameter by specifying a question mark (?) as a placeholder for a literal value. Query and View Designer will give it a temporary name. You can specify as many unnamed parameters in the query as you need.
When you run the query in the Query and View Designer, the Query Parameters Dialog Box is displayed with the temporary name.
-
Add the columns or expressions that you want to search to the Criteria pane. If you do not want the search columns or expressions to appear in the query output, remove them as output columns.
-
Locate the row containing the data column or expression to search, and then in the Filter grid column, enter a question mark (?).
By default, the Query and View Designer adds the "=" operator. However, you can edit the cell to substitute ">", "<", or any other SQL comparison operator.