SQL+parser 源代码

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…

/*本地excel表导入远程服务器*/ insert into openrowset('sqloledb','4BB8377715894B6';'sa';'sa',elcharge.dbo.ec) select * from openrowset(…