How to Know the SQL Transaction is Commited Or Not

To know whether the SQL Transaction is Commited or Not, Use the Following SQL Function

XACT_STATE()

If the Function returns -1 then the transaction is uncommittable state
If the Fucntion returns 1 then the transaction is live and valid and it is in committable state