TABLOCK And TABLOCKX definition example
10,242
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
Author by
Tabriz Atayi
Updated on June 04, 2022Comments
-
Tabriz Atayi almost 2 years
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.