触发器:根据你所触发的某条sql语句来执行另一个sql语句。
SQLSERVER根据添加数据来删除一条数据-触发器
use [client_center_db] --数据库名
go
begin tRAN --开始事务
declare @id int
--添加一条数据
insert into [dbo].[zhuanyongfapiao]([gerenxinxi_id],[zhuanyongfapiao_typeId],[zhuanyongfapiao_fapiaotaitou],[zhuanyongfapiao_zhucedizhi],[zhuanyongfapiao_yinghang],[zhuanyongfapiao_shibiehao],[zhuanyongfapiao_zhucedianhua],[zhuanyongfapiao_yinghangzhanghu])
values (1,1,'我的小卖铺','北京','建设','123456','123','456789')
if @@ERROR>0
GoTo TranRollback --跳转到滚回到标签处
set @id=@@IDENTITY
select count(*) from [zhuanyongfapiao]
use [client_center_db]
go
if(object_id('DeleteFaPiao','TR')is not null)
drop trigger DeleteFaPiao
go
create trigger DeleteFaPiao
on [dbo].[zhuanyongfapiao]
for insert
as
begin
declare @id int
if exists(select * from zhuanyongfapiao)
begin
delete from zhuanyongfapiao where zhuanyongfapiao_id=1009
end
else
begin
print '删除失败'
end
end