ch12 transaction.sql

SQL+Server实用简明教程电子教案和实例源文件

USE ElecTravelCom

DROP TABLE employees
CREATE TABLE employees(
emp_ID INT, 
emp_Name VARCHAR(20))

 



USE ElecTravelCom
BEGIN TRANSACTION
INSERT INTO dbo.employees(emp_ID, emp_Name) VALUES(1, 'Hillary')
SAVE TRANSACTION a
INSERT INTO dbo.employees(emp_ID, emp_Name) VALUES(2, 'Josef')
SAVE TRANSACTION b
INSERT INTO dbo.employees(emp_ID, emp_Name) VALUES(3, 'Michael')
ROLLBACK TRANSACTION b
INSERT INTO dbo.employees(emp_ID, emp_Name) VALUES(4, 'Rudolf')
ROLLBACK TRANSACTION a
COMMIT TRANSACTION
SELECT *
FROM employees





USE ElecTravelCom
GO
SET TRANSACTION ISOLATION LEVEL REPEATABLE READ
GO