BEGIN TRAN, ROLLBACK TRAN, and COMMIT TRAN
Since we specified a BEGIN TRAN, the transaction is now waiting on a ROLLBACK or COMMIT.
While the transaction is waiting it has created a lock on the table and any other processes that are trying to access TABLE are now being blocked. Be careful using BEGIN TRAN and make sure you immediately issue a ROLLBACK or COMMIT!
update TABLE set field = ‘cat’ where istime = 1