导航

2019年3月19日

事务回滚 try catch

摘要： USE tempdb IF OBJECT_ID ('dbo.test') IS NOT NULL DROP TABLE dbo.test GO CREATE TABLE dbo.test ( id INT NOT NULL, CONSTRAINT pk_id PRIMARY KEY (id) ) GO BEGIN TRY BEGIN TRANSACT... 阅读全文

posted @ 2019-03-19 11:17 yiyishuitian 阅读(196) 评论(0) 推荐(0)

事务回滚 SET XACT_ABORT ON

摘要： USE tempdb IF OBJECT_ID ('dbo.test') IS NOT NULL DROP TABLE dbo.test GO CREATE TABLE dbo.test ( id INT NOT NULL, CONSTRAINT pk_id PRIMARY KEY (id) ) GO BEGIN TRANSACTION INSE... 阅读全文

posted @ 2019-03-19 11:12 yiyishuitian 阅读(194) 评论(0) 推荐(0)