LINQ+to+SQL 源代码

--* File Name : build_api2.sql --* Author : DR Timothy S Hall --* Description : Generates a basic API package for the …

1.0 1.2 sql_rt http://java.sun.com/jstl/sql_rt JSTL sql RT JSTL 1.0 sql library org.apache.taglibs.stan…

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