How to specify an unnamed parameter (Enterprise Manager)

To specify an unnamed parameter

  1. Add the columns or expressions that you want to search to the Grid pane. If you do not want the search columns or expressions to appear in the query output, remove them as output columns.
  2. Locate the row containing the data column or expression to search, and then in the Criteria grid column, enter a question mark (?).
  3. By default, the Query Designer adds the “=“ operator. However, you can edit the cell to substitute “>“, “<“, or any other SQL comparison operator.

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.