Locking Hints and Examples are as follows. The usage of them is same same but effect is different. ROWLOCK Use row-level locks when reading or modifying data. PAGLOCK Use page-level locks when reading or modifying data. TABLOCK Use a table lock when reading or modifying data. DBLOCK Use a database lock when reading or modifying… Continue Reading...
Source: SQL SERVER – 2005 Locking Hints and Examples | Journey to SQL Authority with Pinal Dave
No comments:
Post a Comment