MsgHeader 表 ID,SchoolNumber,Dates,UserTypeID
MsgStudBody表 ID,HeaderID,A,B,C
MsgClassBody表 ID,HeaderID,AA,BB,CC如何实现当我删除MsgHeader表中记录时, 同时把MsgStudBody,MsgClassBody表中的记录删除我用如下触发器,做,也不行,只能删除一条记录是可行
Create TRIGGER JXT2_DeleteMsgHeader ON MsgHeader FOR DELETE
AS
DECLARE @HeaderID int
DECLARE @UserTypeID intSELECT @HeaderID=ID,@UserTypeID=UserTypeID FROM deleted IF @UserTypeID = 2
BEGIN
DELETE FROM MsgClassBody WHERE HeaderID = @HeaderID
ENDIF (@UserTypeID = 1) OR (@UserTypeID = 3)
BEGIN
DELETE FROM MsgStudBody WHERE HeaderID = @HeaderID
END
MsgStudBody表 ID,HeaderID,A,B,C
MsgClassBody表 ID,HeaderID,AA,BB,CC如何实现当我删除MsgHeader表中记录时, 同时把MsgStudBody,MsgClassBody表中的记录删除我用如下触发器,做,也不行,只能删除一条记录是可行
Create TRIGGER JXT2_DeleteMsgHeader ON MsgHeader FOR DELETE
AS
DECLARE @HeaderID int
DECLARE @UserTypeID intSELECT @HeaderID=ID,@UserTypeID=UserTypeID FROM deleted IF @UserTypeID = 2
BEGIN
DELETE FROM MsgClassBody WHERE HeaderID = @HeaderID
ENDIF (@UserTypeID = 1) OR (@UserTypeID = 3)
BEGIN
DELETE FROM MsgStudBody WHERE HeaderID = @HeaderID
END
if @@RowCount>1
begin
...
end;