LINQ+to+SQL 源代码

--打开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(…

/*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 = …