https://stackoverflow.com/questions/2334712/how-do-i-update-from-a-select-in-sql-server
How do I UPDATE from a SELECT in SQL Server?
原文：http://www.cnblogs.com/chucklu/p/8075336.html
