This is how developers use the information from the OUTPUT clause.

I got this from this site: http://www.code-magazine.com/Article.aspx?quickid=0501041

DECLARE @UpdatedTable TABLE

(

UpdatedTableID INT,

OldData VARCHAR(20),

NewData VARCHAR(20)

)

UPDATE OutputTest

SET Name = UPPER(Name)

OUTPUT

Inserted.KeyID,

Deleted.Name,

Inserted.Name

INTO @UpdatedTable

SELECT * FROM @UpdatedTable

Results:

UpdatedTableID OldData NewData

6 Jim JIM

7 Markus MARKUS

8 Rod ROD