begin transaction hd use northwind godeclare @hd1 varchar(40)insert into employees (lastname,firstname,title,titleofcourtesy,birthdate) values ('puter','king','Vice President, Salesd','china','1983-04-07 00:00:00.000') select @hd1 = @@error if @hd1=0 print '插入成功' go save transaction hd3declare @hd2 varchar(40) delete from employees where employeeid=10 select @hd2=@@error if @hd2=0 print '删除成功' go
use northwind
godeclare @hd1 varchar(40)insert into employees
(lastname,firstname,title,titleofcourtesy,birthdate)
values
('puter','king','Vice President, Salesd','china','1983-04-07 00:00:00.000')
select @hd1 = @@error
if @hd1=0
print '插入成功'
go
save transaction hd3declare @hd2 varchar(40)
delete
from employees
where employeeid=10
select @hd2=@@error
if @hd2=0
print '删除成功'
go
rollback transaction hd3
commit transaction
begin
print '插入成功'
break
end