加入收藏 | 设为首页 | 会员中心 | 我要投稿 李大同 (https://www.lidatong.com.cn/)- 科技、建站、经验、云计算、5G、大数据,站长网!
当前位置: 首页 > 站长学院 > MsSql教程 > 正文

sqlserver 数据库触发器

发布时间:2020-12-12 13:07:12 所属栏目:MsSql教程 来源:网络整理
导读:create trigger [Tran_alterschemaonly] on database for ALTER_FUNCTION,ALTER_PROCEDURE as ?? ??? ??? ??? ??? ??? ??? ?set ANSI_NULLS ON ?? ??? ??? ??? ??? ??? ??? ?set ANSI_PADDING ON ?? ??? ??? ??? ??? ??? ??? ?set ANSI_WARNINGS ON ?? ??? ?
create trigger [Tran_alterschemaonly] on database for ALTER_FUNCTION,ALTER_PROCEDURE as

?? ??? ??? ??? ??? ??? ??? ?set ANSI_NULLS ON
?? ??? ??? ??? ??? ??? ??? ?set ANSI_PADDING ON
?? ??? ??? ??? ??? ??? ??? ?set ANSI_WARNINGS ON
?? ??? ??? ??? ??? ??? ??? ?set ARITHABORT ON
?? ??? ??? ??? ??? ??? ??? ?set CONCAT_NULL_YIELDS_NULL ON
?? ??? ??? ??? ??? ??? ??? ?set NUMERIC_ROUNDABORT OFF
?? ??? ??? ??? ??? ??? ??? ?set QUOTED_IDENTIFIER ON

?? ??? ??? ??? ??? ??? ??? ?declare @EventData xml
?? ??? ??? ??? ??? ??? ??? ?set @EventData=EventData()?? ?
?? ??? ??? ??? ??? ??? ??? ?exec sys.sp_MStran_ddlrepl @EventData,3
GO
create trigger [Tran_altertable] on database for ALTER_TABLE as

?? ??? ??? ??? ??? ??? ??? ?set ANSI_NULLS ON
?? ??? ??? ??? ??? ??? ??? ?set ANSI_PADDING ON
?? ??? ??? ??? ??? ??? ??? ?set ANSI_WARNINGS ON
?? ??? ??? ??? ??? ??? ??? ?set ARITHABORT ON
?? ??? ??? ??? ??? ??? ??? ?set CONCAT_NULL_YIELDS_NULL ON
?? ??? ??? ??? ??? ??? ??? ?set NUMERIC_ROUNDABORT OFF
?? ??? ??? ??? ??? ??? ??? ?set QUOTED_IDENTIFIER ON

?? ??? ??? ??? ??? ??? ??? ?declare @EventData xml
?? ??? ??? ??? ??? ??? ??? ?set @EventData=EventData()?? ?
?? ??? ??? ??? ??? ??? ??? ?exec sys.sp_MStran_ddlrepl @EventData,1

GO

create trigger [Tran_altertrigger] on database for ALTER_TRIGGER as ?? ??? ??? ??? ??? ??? ??? ?set ANSI_NULLS ON ?? ??? ??? ??? ??? ??? ??? ?set ANSI_PADDING ON ?? ??? ??? ??? ??? ??? ??? ?set ANSI_WARNINGS ON ?? ??? ??? ??? ??? ??? ??? ?set ARITHABORT ON ?? ??? ??? ??? ??? ??? ??? ?set CONCAT_NULL_YIELDS_NULL ON ?? ??? ??? ??? ??? ??? ??? ?set NUMERIC_ROUNDABORT OFF ?? ??? ??? ??? ??? ??? ??? ?set QUOTED_IDENTIFIER ON ?? ??? ??? ??? ??? ??? ??? ?declare @EventData xml ?? ??? ??? ??? ??? ??? ??? ?set @EventData=EventData()?? ? ?? ??? ??? ??? ??? ??? ??? ?exec sys.sp_MStran_ddlrepl @EventData,4 GO create trigger [Tran_alterview] on database for ALTER_VIEW as ?? ??? ??? ??? ??? ??? ??? ?set ANSI_NULLS ON ?? ??? ??? ??? ??? ??? ??? ?set ANSI_PADDING ON ?? ??? ??? ??? ??? ??? ??? ?set ANSI_WARNINGS ON ?? ??? ??? ??? ??? ??? ??? ?set ARITHABORT ON ?? ??? ??? ??? ??? ??? ??? ?set CONCAT_NULL_YIELDS_NULL ON ?? ??? ??? ??? ??? ??? ??? ?set NUMERIC_ROUNDABORT OFF ?? ??? ??? ??? ??? ??? ??? ?set QUOTED_IDENTIFIER ON ?? ??? ??? ??? ??? ??? ??? ?declare @EventData xml ?? ??? ??? ??? ??? ??? ??? ?set @EventData=EventData()?? ? ?? ??? ??? ??? ??? ??? ??? ?exec sys.sp_MStran_ddlrepl @EventData,2 GO

(编辑:李大同)

【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!

    推荐文章
      热点阅读