Description

transition-variable
Identifies the column to be updated in the new row. A transition-variable must identify a column in the subject table of a trigger, optionally qualified by a correlation name that identifies the new value. An OLD transition-variable must not be identified.

A transition-variable must not be identified more than once in the same SET transition-variable statement.

The data type of each transition-variable must be compatible with its corresponding result column. Values are assigned to transition-variables according to the assignment rules to a column. For more information see Assignments and comparisons.

expression
Specifies the new value of the transition-variable. The expression is any expression of the type described in Expressions. The expression cannot include an aggregate function.

An expression may contain references to OLD and NEW transition-variables. If the CREATE TRIGGER statement contains both OLD and NEW clauses, references to transition-variables must be qualified by the correlation-name.

NULL
Specifies the null value. NULL can only be specified for nullable columns.
DEFAULT
Specifies that the default value of the column associated with the transition-variable will be used. DEFAULT is not allowed if the column is an IDENTITY column or has a ROWID data type.
row-fullselect
A fullselect that returns a single result row. The result column values are assigned to each corresponding transition-variable. If the result of the fullselect is no rows, then null values are assigned. An error is returned if there is more than one row in the result.