Microsoft SQL Server uses a lock hierarchy whenever the data is read or something is changed in the data. Whenever a row is read, SQL Server acquires a shared lock. Similarly, as soon as we change a row, SQL Server acquires an Exclusive lock. These locks are incompatible with each other. So, the INTENT locks are used to indicate at a higher level which locks are applied within a lock hierarchy.
There are mainly three kinds of INTENT locks :
* Intent Shared Lock(IS) : This lock is used when you have a shared lock at the row level.
* Intent Update Lock(IU) : The Intent update lock is used when you have an update lock at the row level.
* Intext Exclusive Lock(IX) : This lock is used when you have an exclusive lock at the row level.
