OUTPUT

http://msdn.microsoft.com/en-us/library/ms177564.aspx

-- INSERT INTO.... OUTPUT INSERTED

INSERT INTO HR.Staff ( FirstName, LastName )

OUTPUT INSERTED.StaffID, DATEADD(d,90,GETDATE()),'90-Day Review'

INTO HR.Notification

    (

        StaffID,

        NotificationDate,

        NotificationType

    )

VALUES  ( 'Santa','Claus')

http://www.mssqltips.com/tip.asp?tip=2183&home

-- UPDATE .... OUTPUT

UPDATE Production.Document

SET DocumentSummary .WRITE (N'features',28,10)

OUTPUT deleted.DocumentSummary, 

       inserted.DocumentSummary 

    INTO @MyTableVar

WHERE Title = N'Front Reflector Bracket Installation'

-- save the results of a DELETE statement into a table variable

DELETE Sales.ShoppingCartItem

OUTPUT DELETED.* 

WHERE ShoppingCartID = 20621

http://msdn.microsoft.com/en-us/library/ms189835.aspx