The OUTPUT clause is not supported in any DML statements that target remote tables or views. 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. Table2 (d1 int PRIMARY KEY NOT NULL, d2 int NOT NULL); GO INSERT INTO dbo. Table2 VALUES (1, 20), (2, 30); GO DECLARE abc CURSOR LOCAL FOR SELECT c1, c2 FROM dbo. Table1; GO Support for use of the READUNCOMMITTED and NOLOCK hints in the FROM clause that apply to the target table of an UPDATE or DELETE statement will be removed in a future version of SQL Server.If the object being updated appears more than one time in the FROM clause, one, and only one, reference to the object must not specify a table alias. Avoid using these hints in this context in new development work, and plan to modify applications that currently use them.The returning clause retrieves the rows affected by a DML statement.
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.
When used in the subquery of a DML statement, you can specify this clause in a subquery in the can be a subquery, a column, a function, or a collection constructor.
Regardless of its form, it must return a collection value—that is, a value whose type is nested table or varray.
SET column_name = (subquery3) Assigns the value retrieved from the database by list.