⚠️ ARCHIVED WEBSITE, NO FURTHER UPDATES ⚠️
383 shaares
79 private links
79 private links
1 result
tagged
sql
Unlike the BULK INSERT statement, which holds a less restrictive Bulk Update lock, INSERT INTO...SELECT with the TABLOCK hint holds an exclusive (X) lock on the table. This means that you cannot insert rows using parallel insert operations.