关于创建触发器的问题

Question

create trigger del_permission
   on role_permission
   for DELETE
  as 
   delete from TempPermission,deleted 
        where TempPermission.PermissionID=deleted.PermissionID and   
     TempPermission.RoleName=deleted.RoleName

Answer 1

create trigger del_permission
   on role_permission
   for DELETE
  as 
   delete TempPermission from TempPermission,deleted 
        where TempPermission.PermissionID=deleted.PermissionID and   
     TempPermission.RoleName=deleted.RoleName

Answer 2

你好，第二个sql要是不是delete 就可以使用 deleted 表
可以这样修改create trigger del_permission
   on role_permission
   AFTER DELETE
  as 
declare @parm char(50)
   if(select count(*) from TempPermission,deleted 
      where TempPermission.PermissionID=deleted.PermissionID and      
      TempPermission.RoleName=deleted.RoleName)<>0
    begin
     select   @pram= RoleName from deleted    
    delete from TempPermission 
        where TempPermission.PermissionID=deleted.PermissionID and   
     TempPermission.RoleName=@pram
  end