常用SQL整理 - UPDATE FROM

DECLARE @T1 TABLE(ID INT,A INT)DECLARE @T2 TABLE(ID INT,B INT)INSERT @T1        ( ID, A )VALUES  ( 1, -- ID - int          0  -- A - int          )INSERT @T1        ( ID, A )VALUES  ( 2, -- ID - int          2  -- A - int          )INSERT @T2        ( ID, B )VALUES  ( 1, -- ID - int          111  -- A - int          )UPDATE @T1SET A = BFROM @T1 A,@T2 BWHERE A.ID = B.IDSELECT * FROM @T1