rtmloop.txt

来自「本人使用SQL SERVER 数据库3年」· 文本 代码 · 共 74 行

/* RTMLoop.txt */

USE LumigentDemoDB

/* Add a set of customers to the database.  Insert delays to create long-running transactions */


BEGIN TRAN T1
UPDATE Customers SET Address='714 Haight Street' WHERE Last='Garcia' 
UPDATE Customers SET Address='710 Haight Street' WHERE Last='Garcia' 
WAITFOR DELAY '000:00:01'
INSERT Customers (CustID, Last,First) VALUES(4,'Hendrix','Jimi') 
DELETE Customers Where Last='Hendrix'
COMMIT

BEGIN TRAN T2
UPDATE Customers SET Address='714 Haight Street' WHERE Last='Garcia' 
UPDATE Customers SET Address='710 Haight Street' WHERE Last='Garcia' 
INSERT Customers (CustID, Last,First) VALUES(4,'Hendrix','Jimi') 
DELETE Customers Where Last='Hendrix'
WAITFOR DELAY '000:00:01'
COMMIT

BEGIN TRAN T3
UPDATE Customers SET Address='714 Haight Street' WHERE Last='Garcia' 
UPDATE Customers SET Address='710 Haight Street' WHERE Last='Garcia' 
INSERT Customers (CustID, Last,First) VALUES(4,'Hendrix','Jimi') 
DELETE Customers Where Last='Hendrix'
COMMIT

BEGIN TRAN T4
UPDATE Customers SET Address='714 Haight Street' WHERE Last='Garcia' 
UPDATE Customers SET Address='710 Haight Street' WHERE Last='Garcia' 
INSERT Customers (CustID, Last,First) VALUES(4,'Hendrix','Jimi') 
DELETE Customers Where Last='Hendrix'
WAITFOR DELAY '000:00:03'
COMMIT

BEGIN TRAN T5
UPDATE Customers SET Address='714 Haight Street' WHERE Last='Garcia' 
UPDATE Customers SET Address='710 Haight Street' WHERE Last='Garcia' 
INSERT Customers (CustID, Last,First) VALUES(4,'Hendrix','Jimi') 
DELETE Customers Where Last='Hendrix'
WAITFOR DELAY '000:00:01'
COMMIT

BEGIN TRAN T6
UPDATE Customers SET Address='714 Haight Street' WHERE Last='Garcia' 
UPDATE Customers SET Address='710 Haight Street' WHERE Last='Garcia' 
INSERT Customers (CustID, Last,First) VALUES(4,'Hendrix','Jimi') 
DELETE Customers Where Last='Hendrix'
WAITFOR DELAY '000:00:04'
COMMIT

BEGIN TRAN T7
UPDATE Customers SET Address='714 Haight Street' WHERE Last='Garcia' 
WAITFOR DELAY '000:00:02'
UPDATE Customers SET Address='710 Haight Street' WHERE Last='Garcia' 
INSERT Customers (CustID, Last,First) VALUES(4,'Hendrix','Jimi') 
DELETE Customers Where Last='Hendrix'
COMMIT

BEGIN TRAN
INSERT Customers (CustID,Last,First,Address,City,Region,PostalCode,Country) VALUES(5,'Joplin','Janis','645 Fourth Street','Port Arthur','TX','77641','USA') 
COMMIT

BEGIN TRAN
INSERT Customers (CustID,Last,First,Address,City,Region,PostalCode,Country) VALUES(6,'Marley','Bob','Manley Boulevard','Kingston','Jamaica','W64 15S','JWI') 
COMMIT

sp_grantdbaccess 'Demo_Login', 'Demo_Login'

ALTER TABLE [dbo].[employees] ADD [years] INT