SQL+parser 源代码

/*sql返回的字段顺序是按字段名排序的，并不是Excel中的ABCD...列顺序*/ use elcharge insert into ec select * from openrowset('MicroSoft.Jet.OleDB.4.0','E…

declare @tran_name varchar(20) set @tran_name ='mytran1' begin transaction @tran_name go use test go update stucopy …

--定义一个局部变量@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…