How to create an Update query (Enterprise Manager)

To create an Update query

1. Add the table you want to update to the Diagram pane.
2. Convert the default query to an Update query by right-clicking in the Diagram or SQL pane, choosing Change Type, and then choosing Update.

   ---

   Note If more than one table is displayed in the Diagram pane when you start the Update query, the Query Designer displays the Update Table dialog box to prompt you for the name of the table to update.

   ---

3. Define the data columns to update by adding them to the query. For details, see Adding Columns. Columns will be updated only if you add them to the query.
4. In the New Value column of the Grid pane, enter the update value for the column. You can enter literal values, column names, or expressions. The value must match (or be compatible with) the data type of the column you are updating.

   ---

   Caution The Query Designer cannot check that a value fits within the length of the column you are updating. If you provide a value that is too long, it might be truncated without warning. For example, if a name column is 20 characters long but you specify an update value of 25 characters, the last 5 characters might be truncated.

   ---

5. Define the rows to update by entering search conditions in the Criteria column. For details, see Specifying Search Conditions.

   If you do not specify a search condition, all rows in the specified table will be updated.

   ---

   Note When you add a column to the Grid pane for use in a search condition, the Query Designer also adds it to the list of columns to be updated. If you want to use a column for a search condition but not update it, clear the check box next to the column name in the input source window.

   ---

   When you execute an Update query, no results are reported in the Results pane. Instead, a message appears indicating how many rows were changed.