How to avoid Deadlock in SQL ?

Avoid Deadlock

We need to introduce NOLOCK keyword to avoid deadlock.

Select * from TBL1 NOLOCK


Select * from TBL1 with NOLOCK

How to avoid Deadlock in SQL ? was last modified: February 21st, 2017 by Justin Antony

About Justin Antony


  1. Hi there to every body, it’s my first go to see of this blog; this website consists of
    remarkable and really excellent information for readers.

Leave a Reply