Compound assignment operator: = Add and assign -= Subtract and assign *= Multiply and assign /= Divide and assign %= Modulo and assign &= Bitwise AND and assign ^= Bitwise XOR and assign |= Bitwise OR and assign Returns updated data or expressions based on it as part of the UPDATE operation.
The OUTPUT clause is not supported in any DML statements that target remote tables or views.
State Province ID; GO You cannot use SELECT INTO to create a partitioned table even when the source table is partitioned.
Specifies the temporary named result set or view, also known as common table expression (CTE), defined within the scope of the UPDATE statement.
The FILESTREAM attribute does not transfer when you create a new table by using the SELECT INTO statement.
The WHERE clause specifies which record(s) that should be updated.
A view with an INSTEAD OF UPDATE trigger cannot be a target of an UPDATE with a FROM clause.
Note Any call to OPENDATASOURCE, OPENQUERY, or OPENROWSET in the FROM clause is evaluated separately and independently from any call to these functions used as the target of the update, even if identical arguments are supplied to the two calls.
For more information, see OUTPUT Clause (Transact-SQL).
FROM Specifies that a table, view, or derived table source is used to provide the criteria for the update operation. If the object being updated is the same as the object in the FROM clause and there is only one reference to the object in the FROM clause, an object alias may or may not be specified.