TableLock

--大量INSERT + TableLock

INSERT INTO dbo.DstTable WITH (TABLOCK)
(ID, FLD1)
SELECT * FROM dbo.SrcTable;