代码搜索：sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/375429/9360179
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/9360181
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/9360184
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
www.eeworm.com/read/375429/9360186
sql 1008.sql
BEGIN TRANSACTION
USE pubs
GO
UPDATE titles
SET advance = advance * 1.25
WHERE ytd_sales > 8000
GO
COMMIT TRANSACTION
GO
www.eeworm.com/read/375429/9360188
sql totalcredit.sql
use test
go
if exists(select name from sysobjects where nanme = 'totalcredit' and type = 'p')
drop procedure totalcredit
go
use test
go
create procedure totalcredit @name varchar(10),
www.eeworm.com/read/375429/9360190
sql dtsrun.sql
CREATE PROCEDURE my_proc11 AS
exec master..xp_cmdshell 'dtsrun /F F:\AccessToSQL\AccessToSQL.dts'
GO