TABLOCK And TABLOCKX definition example

Question

Can someone explain TABLOCKX and TABLOCK keyword and show examples anout this keyword.

What is the functions of these 2 words in queries?

Thank you.

possible duplicate of [TABLOCK vs TABLOCKX](http://stackoverflow.com/questions/5102152/tablock-vs-tablockx) — Martin Smith, Oct 25 '11 at 08:52
Homework question http://stackoverflow.com/questions/5102152/tablock-vs-tablockx — Kip Real, Oct 27 '11 at 11:36

score 3 · Answer 1 · answered Mar 27 '12 at 15:32

3

i use the "WITH (TABLOCK)" statement in an insert into an empty clustered table to minimally log the transaction:

INSERT INTO myTable WITH (TABLOCK)
(Column1, Column2...)
SELECT X, Y from Z

answered Mar 27 '12 at 15:32

elvis

score 0 · Answer 2 · answered Oct 25 '11 at 13:29

0

TABLOCK obtains a shared lock, and TABLOCKX obtains an exclusive lock.

Here's an example of both:

select *
from yourtableSharedLock
with (tablock)

select *
from yourtableExclusiveLock
with (tablockx)

answered Oct 25 '11 at 13:29

2 Answers2