触发器最终版增删改最简单的一个

最新推荐文章于 2023-05-31 11:09:57 发布

sciinfojs123

最新推荐文章于 2023-05-31 11:09:57 发布

阅读量836

点赞数 1

分类专栏： sql

本文链接：https://blog.csdn.net/shamao1113/article/details/48710783

版权

sql 专栏收录该内容

3 篇文章 0 订阅

订阅专栏


alter trigger addFileMailData00000000000010
on [testOAone].[dbo].[FileMailData00000000000010]
instead of  insert
as
insert into [testOAone].[dbo].[FileMailData00000000000010](RecUser,MailTit,ExamineState)
select  inserted.RecUser,inserted.MailTit,inserted.ExamineState from inserted 
insert into [testOAtwo].[dbo].[DZM_FileMailData00000000000010](RecUser,MailTit,ExamineState)
select  inserted.RecUser,inserted.MailTit,inserted.ExamineState from inserted 


alter trigger updateFileMailData00000000000010
on [testOAone].[dbo].[FileMailData00000000000010] 
instead of  update
as
Update [testOAtwo].[dbo].[DZM_FileMailData00000000000010]           
Set MailTit=i.MailTit           
From [testOAtwo].[dbo].[DZM_FileMailData00000000000010] br , Deleted   d ,Inserted i      --Deleted和Inserted临时表           
Where br.ID=d.ID








alter trigger deleteFileMailData00000000000010
on [testOAone].[dbo].[FileMailData00000000000010]
instead of  delete 
as
delete from [testOAone].[dbo].[FileMailData00000000000010]
where ID in
(select ID from deleted) 


delete from [testOAtwo].[dbo].[DZM_FileMailData00000000000010]
where ID in
(select ID from deleted)