Spark-SQL 源代码

--定义一个局部变量@TranName DECLARE @TranName VARCHAR(20) --给局部变量@TranName赋值 SELECT @TranName = 'MyTransaction' --定义事务 BEGIN TRANSACT…

SET IMPLICIT_TRANSACTIONS ON GO

USE 学生成绩数据库 GO /*事务开始的标识*/ BEGIN TRAN TEMPTRAN INSERT INTO 学生表(学号,姓名,性别,院系名称,班级代号,出生日期,入学年月) VALUES ('20040008','柳月红','女…

USE pubs GO --定义分布式事务 BEGIN DISTRIBUTED TRANSACTION --在本机上执行SQL语句 UPDATE authors SET au_lname = 'McDonald' WHERE au_id = …

SET TRANSACTION ISOLATION LEVEL REPEATABLE READ GO BEGIN TRANSACTION USE PUBS GO SELECT * FROM publishers SELECT * FROM auth…

SELECT * FROM MASTER..SYSLOCKINFO GO

SET IMPLICIT_TRANSACTIONS OFF GO

--打开PUBS数据库，创建表TestTrans USE pubs GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TestTrans]') and OBJ…

EXEC SP_LOCK GO

BEGIN TRANSACTION USE pubs GO UPDATE titles SET advance = advance * 1.25 WHERE ytd_sales > 8000 GO COMMIT TRANSACTION…