SQL Locks for table creation

SQL

Download (.zip)

USE PUBS
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
BEGIN TRAN
SELECT *
INTO newTitles
FROM titles
WHERE price < 5
EXEC sp_lock2 @@spid
COMMIT TRAN

SQLCorrelated subquery with derived table Creat table nc heap nodupes Creat table nc nodupes
SQLCreat table nc overlap Create table clustered dupes Create table clustered nodupes
SQLCreate table waitstats Delete from clustered table Forward pointers
SQLFunc MyDateFormat Locks for table creation Proc count tables
SQLRelated tables Repeatable read mode row locks