Home
Submit
Free Hosting
Link To Us
Contacts
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
SQL
Correlated subquery with derived table
Creat table nc heap nodupes
Creat table nc nodupes
SQL
Creat table nc overlap
Create table clustered dupes
Create table clustered nodupes
SQL
Create table waitstats
Delete from clustered table
Forward pointers
SQL
Func MyDateFormat
Locks for table creation
Proc count tables
SQL
Related tables
Repeatable read mode
row locks