Table Update Showplan Operator

The Table Update physical operator updates input rows in the table specified in the Argument column of the query execution plan. The SET:() predicate determines the value of each updated column. These values may be referenced in the SET clause or elsewhere within this operator as well as elsewhere within this query.

Table update operator iconGraphical execution plan icon

See Also

Tasks

How to: Display an Actual Execution Plan

Concepts

Logical and Physical Operators Reference
Displaying Execution Plans by Using the Showplan SET Options (Transact-SQL)

Other Resources

UPDATE (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance