How to specify a named parameter (Enterprise Manager)

To specify a named parameter

  1. If you have not done so already, specify the parameter marker characters. For details, see Specifying Parameter Marker Characters.
  2. Add the columns or expressions that you want to search to the Grid pane. If you are creating a Select query and do not want the search columns or expressions to appear in the query output, remove them as output columns.
  3. Locate the row containing the data column or expression to search, and then in the Criteria grid column, enter the name of the parameter. Be sure to mark the parameter using the appropriate characters.

    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.