两个表 触发器 冲突

两个表之间互相插入与删除记录

我把触发器记录一下,哈哈。首次学,首次写。

对[dbo].[DNN_Roles]表的插入与删除之后进行操作
create TRIGGER Trigger_DNN_UNIRMS_ADDROLES
   ON  [dbo].[DNN_Roles]
   for INSERT
AS
BEGIN   
    declare @RoleName as VARCHAR(256)
    select @RoleName=RoleName from INSERTED
    exec [dbo].[aspnet_Roles_CreateRole] "DotNetNuke",@RoleName 
END

create TRIGGER [dbo].[Trigger_DNN_UNIRMS_DELETEROLES]
   ON  [dbo].[DNN_Roles]
   for delete
AS
BEGIN   
    declare @RoleName as VARCHAR(256)
    select @RoleName=RoleName from deleted
    exec [dbo].[aspnet_Roles_DeleteRole] "DotNetNuke",@RoleName,1
END

对[dbo].[aspnet_Roles]表的插入与删除之后进行操作:

create TRIGGER Trigger_UNIRMS_DNN_ADDROLES
   ON  [dbo].[aspnet_Roles]
   for insert
AS
BEGIN   
    declare @RoleName2 as nvarchar(256)
    select @RoleName2=RoleName from inserted
    exec dbo.DNN_AddRole 0,NULL,@RoleName2,'','$0.0000',1,'N','$0.0000',1,'N',0,0,'',''
END

create TRIGGER [dbo].[Trigger_UNIRMS_DNN_DELETEROLES]
   ON  [dbo].[aspnet_Roles]
   for delete
AS
BEGIN   
    declare @RoleId as int
    declare @RoleName as VARCHAR(256)

    select @RoleName=RoleName from deleted
    select @RoleId=RoleId from DNN_Roles where RoleName=@RoleName

    exec [dbo].[DNN_DeleteRole] @RoleId
END

执行后会出现冲突问题,也就是递归的问题。
我把数据库的服务器设置一下就好了。
右击服务器属性->高级->杂项(右边窗口)->允许触发器激发其他触发器 设置成False






posted @ 2007-09-23 10:50  LeoXu  阅读(630)  评论(0编辑  收藏  举报
阿里云服务器购买页