UPDATE from SELECT using SQL Server - Stack Overflow

In SQL Server you can insert into a table using a select statement: ... UPDATE Table SET Table.col1 = other_table.col1, Table.col2 .... I'd modify ...

www.google.com.tw