Uncategorized

Effect of @@trancount with transactions in Sql Server

Hi friends, while working a scenario I found some interesting fact about @@TRANCOUNT when we used IMPLICIT transaction & BEGIN TRANSACTION in Sql Server. I will create some scenarios and we will look how things get changed. As we know that @@TRANCOUNT function is used to find the level of transaction. When @@TRANCOUNT > 0… Continue reading Effect of @@trancount with transactions in Sql Server