You can use the @@TRANCOUNT function to determine whether any open transactions exist and how deeply they are nested.
A BEGIN TRANSACTION statement increments @@TRANCOUNT by one, and a ROLLBACK statement sets @@TRANCOUNT to zero.

Exploring the Latest Tech Trends Impacting the Real Estate Industry
The real estate industry is changing thanks to the newest technological advancements. These new developments — from blockchain and AI to virtual reality and 3D printing — are poised to change how we buy and sell homes. Real estate brokers, buyers, sellers, wholesale real estate professionals, fix and flippers, and beyond may