Editing Transact-SQL (section)

==Changes to DELETE and UPDATE statements==
In Transact-SQL, both the <code>DELETE</code> and <code>UPDATE</code> statements are enhanced to enable data from another table to be used in the operation, without needing a subquery:
* <code>DELETE</code> accepts joined tables in the <code>FROM</code> clause, similarly to <code>SELECT</code>.  When this is done, the name or alias of which table in the join is to be deleted from is placed between <code>DELETE</code> and <code>FROM</code>.
* <code>UPDATE</code> allows a <code>FROM</code> clause to be added.  The table to be updated can be either joined in the <code>FROM</code> clause and referenced by alias, or referenced only at the start of the statement as per standard SQL.

This example deletes all {{code|users}} who have been flagged in the {{code|user_flags}} table with the 'idle' flag.
<syntaxhighlight lang="tsql">
DELETE u
FROM users AS u INNER JOIN user_flags AS f ON u.id = f.id
WHERE f.name = 'idle';
</syntaxhighlight>