CREATE TABLE VENKATOutput
(
   KeyID INT Identity, 
   Name CHAR(20)
)

GO
INSERT INTO VENKATOutput(Name) Values ('Jim')
INSERT INTO VENKATOutput(Name) Values ('Markus')
INSERT INTO VENKATOutput(Name) Values ('Rod')
INSERT INTO VENKATOutput(Name) Values ('John')
INSERT INTO VENKATOutput(Name) Values ('Alan')
GO
SELECT * FROM VENKATOutput


--  Utilizing the OUTPUT clause with UPDATE
--  THIS WILL RETRIEVE THE DATAS WHICH ARE UPDATED BY THE UPDATE QUERY
DECLARE @UpdatedTable TABLE(UpdatedTableID INT, OldData VARCHAR(20),  NewData VARCHAR(20))

UPDATE VENKATOutput SET Name = UPPER(Name)
		OUTPUT  Inserted.KeyID,  Deleted.Name, Inserted.Name INTO @UpdatedTable
SELECT * FROM @UpdatedTable

SELECT * FROM VENKATOutput