UPDATE (Transact-SQL) - MSDN - Microsoft

變更SQL Server 2014 資料表或檢視表中現有的資料。 如需範例，請 ... UPDATE statement with CTE references that are incorrectly matched. USE tempdb; GO ...

msdn.microsoft.com