SafeDestructiveSQL.sql

BEGIN TRAN

UPDATE person
SET firstname='Omar' 
OUTPUT deleted.*, inserted.* 
where firstname='Omarr'

ROLLBACK TRAN

--OR

BEGIN TRAN

UPDATE person
SET firstname='Omar' 
OUTPUT deleted.firstname, inserted.firstname 
where firstname='Omarr'

ROLLBACK TRAN


--firstname	firstname
--Omarr	    Omar