BEGIN TRANSACTION and COMMIT TRANSACTION

home
database
view story

1 Kicks

BEGIN TRANSACTION and COMMIT TRANSACTION(soliddotnet.com)

submitted by neerajmathur(130) 2 years, 7 months ago

I know everyone will be thinking why am i posting about BEGIN TRANSACTION and COMMIT TRANSACTION which are the very basic and common thing that every one is known about it and why and where we we need to use this statement in sql statements/queries or in our code. But sometimes, we make such kind of small mistake with this BEGIN and COMMIT statement that make a cause of deadlock in our application and when it happens no one thinks that this could be the reason of the dead lock. The same problem i faced sometimes back.

add a comment |category: Database |Views: 14
Tweet