SQL Server combine Update and Delete Is it possible to combine both update and delete in a single SQL statement? I would like to execute something like this:

update a
set a.value = a.value + b.value
from Table1 a
join Table2 b on a.ID = b.ID


Also, rows, which has value higher than some constant number, should be deleted.
You can't combine them in one statement but you can wrap them into one transaction.

BEGIN TRANSACTION
  update a
  set a.value = a.value + b.value
  from Table1 a
  join Table2 b on a.ID = b.ID;

  DELETE FROM Table1 WHERE Table1.Value &gt; @Constant;
COMMIT TRANSACTION ;