特殊的存储过程:
create trigger ins_upd_orders
on orders for insert,update
as
if exists(select * from orders)
begin
raiserror(60000,16,1)
rollback tran
update employees set employeeid =16 where employeeid =7
end
create procedure proc_test
@Value int,
@Id int
as
BEGIN TRAN t1
update test1 set value=@value where id=@id
if @@error<>0 goto err_h
update test2 set value=@value where id=@id
if @@error<>0 goto err_h
COMMIT TRAN t1
return 0
err_h:
ROLLBACK TRAN t1
return -1
go