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.

Answer 1

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