Idea - Gathering Feedback BEGIN TRAN, ROLLBACK TRAN, and COMMIT TRAN

Not sure if this would be possible, but it would be nice to be able to use the BEGIN TRAN, ROLLBACK TRAN, and COMMIT TRAN SQL statements. They are useful when doing UPDATE and DELETE statements because you can do something like:

BEGIN TRAN
UPDATE Table SET Column='New Value"
WHERE...

then make sure that the number of rows updated is the number of rows that you expected to update.

This allows you to ROLLBACK TRAN or COMMIT TRAN accordingly.