USE AdventureWorks;  

GO  

CREATE TABLE TestTable (ID INT, TEXTVal VARCHAR(100))  

DECLARE @TmpTable TABLE (ID_New INT, TEXTVal_New VARCHAR(100),ID_Old INT, TEXTVal_Old VARCHAR(100))  

INSERT TestTable (ID, TEXTVal)  VALUES (1,'FirstVal')  

INSERT TestTable (ID, TEXTVal)  VALUES (2,'SecondVal')  


UPDATE TestTable  

SET TEXTVal = 'NewValue'  

OUTPUT Inserted.ID, Inserted.TEXTVal, Deleted.ID, Deleted.TEXTVal INTO @TmpTable  

WHERE ID IN (1,2)  

  

SELECT * FROM @TmpTable  

SELECT * FROM TestTable  


DROP TABLE TestTable  

GO