Syntax update statement ::= Description of the illustration update_Keyword and Parameter Description alias Another (usually short) name for the referenced table or view, typically used in the contains references to columns in the table being updated, the references are resolved in the context of the current row.The old column values are used on the right side of the equal sign.
Set dbs = Open Database("Northwind.mdb") ' Change values in the Reports To field to 5 for all ' employee records that currently have Reports To ' values of 2. Execute "UPDATE Employees " _ & "SET Reports To = 5 " _ & "WHERE Reports To = 2;" dbs.
The following example returns the date of the most recent update for each statistics object on the value in the sys.indexes catalog view, and the following query returns the same results as the preceding query.
If statistics do not correspond to an index, they are in the sys.stats results but not in the sys.indexes results.
UPDATE() is used anywhere inside the body of a Transact-SQL INSERT or UPDATE trigger to test whether the trigger should execute certain actions.
Transact-SQL Syntax Conventions Is the name of the column to test for either an INSERT or UPDATE action.
The following example creates statistics on the Last Name column of the Dim Customer table.