SQL Server supports it. select 1 as id, 100 as value into #tmp update a set a.value = 2000 from #tmp a where a.id = 1; Useful when you update a table using an inner or left join with another table and the new values come from the second table.
SQL Server supports it. select 1 as id, 100 as value into #tmp update a set a.value = 2000 from #tmp a where a.id = 1; Useful when you update a table using an inner or left join with another table and the new values come from the second table.