How to make a unique transaction (which will not be repeated)?

Question

SQL

SET XACT_ABORT ON;
BEGIN TRAN UN_name-141242141515151235566451;
...
IF @@ERROR = 0  COMMIT TRAN UN_name-141242141515151235566451 
ELSE 
ROLLBACK TRAN UN_name-141242141515151235566451;

You need to make sure that the transaction with UN_name-141242141515151235566451 is executed once an hour. A retransaction with this name was blocked.

Answer 1

UUID?