Are you looking for something like OUTPUT? http://msdn.microsoft.com/en-us/library/ms177564.aspx

I know in cases when you run an UPDATE you can use this to view the deleted.fieldname (old version), inserted.fieldname (new version) etc.