我现在有3张关联的表 用户表和用户权限表 当根据用户编号删除一个用户时,相应的权限也要删除
我想到触发器 只是不会写
用户表有字段
Userid
UserName
Userpwd
Userdept
Userrole
creatrdate用户权限分配表有
UserID
MenuID
权限菜单有
menu_id
menu-name
我想到触发器 只是不会写
用户表有字段
Userid
UserName
Userpwd
Userdept
Userrole
creatrdate用户权限分配表有
UserID
MenuID
权限菜单有
menu_id
menu-name
create trigger name on User after delete
as
begin
declare @id int
select @n_id =Userid from deleted
delete 用户权限表 where UserID = @id
end
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
ALTER TRIGGER [dbo].[trigDeleteAll]
ON [dbo].[SoftInfo]
for DELETE
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON; -- Insert statements for trigger here declare @appId varchar(100) select @appId = [ID] from deleted
delete from Maintenance where SoftId = @appId
delete from Feedback where SoftId = @appId
delete from AppError where SoftId = @appIdEND
as
begin
declare @id int
select @id =Userid from deleted
delete from 用户权限表 where UserID = @id
end