SQL Locks for table creation
Locks for table creation
USE PUBS
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
BEGIN TRAN
SELECT *
INTO newTitles
FROM titles
WHERE price < 5
EXEC sp_lock2 @@spid
COMMIT TRAN
CODE
LIBARY.COM