代码搜索：sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/375429/9360225
sql grant.sql
use test
go
grant all to chen
go
grant all on stucopy to chen
go
www.eeworm.com/read/375429/9360230
sql 1007.sql
--定义一个局部变量@TranName
DECLARE @TranName VARCHAR(20)
--给局部变量@TranName赋值
SELECT @TranName = 'MyTransaction'
--定义事务
BEGIN TRANSACTION @TranName
GO
USE pubs
GO
UPDATE roysched
SET royalty
www.eeworm.com/read/375429/9360234
sql 1009.sql
USE 学生成绩数据库
GO
/*事务开始的标识*/
BEGIN TRAN TEMPTRAN
INSERT INTO 学生表(学号,姓名,性别,院系名称,班级代号,出生日期,入学年月)
VALUES ('20040008','柳月红','女','计算机','200401','1973-5-20','200409')
/*将事务保存一个保存点*/
SAVE TRAN IN
www.eeworm.com/read/375429/9360236
sql 1002.sql
USE pubs
GO
--定义分布式事务
BEGIN DISTRIBUTED TRANSACTION
--在本机上执行SQL语句
UPDATE authors
SET au_lname = 'McDonald' WHERE au_id = '409-56-7008'
--在远程名为remote的服务器上执行一个名为changeauth_lname的存储过程
EXECUTE
www.eeworm.com/read/375429/9360238
sql 1010.sql
SET TRANSACTION ISOLATION LEVEL REPEATABLE READ
GO
BEGIN TRANSACTION
USE PUBS
GO
SELECT * FROM publishers
SELECT * FROM authors
COMMIT TRANSACTION
GO
www.eeworm.com/read/375429/9360244
sql 1001.sql
--打开PUBS数据库，创建表TestTrans
USE pubs
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TestTrans]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TestTrans]
GO