Subqueries in UPDATE, DELETE, and INSERT Statements - TechNet

Subqueries can be nested in the UPDATE, DELETE, INSERT and SELECT data ... SQL Server 2008 R2 ... Here is an equivalent UPDATE statement using a join:.

www.google.com.tw