1) some time we use ROWLOCK like SELECT * FROM TESTTABLE WITH (ROWLOCK) WHERE ID IN (1,2,2,4,5)
ROWLOCK actually lock the row ? what isolation should be used for ROWLOCK ?
i always use sql server default isolation.
2) what is UPDLOCK does ? how and when it lock the row if we use UPDLOCK in select statement?
3) what is HOLDLOCK ? when it is used and what it does ?
i saw often HOLDLOCK used along with UPDLOCK. why ?
please share knowledge. thanks