兄弟们,明细表删除问题问题,帮忙了.

[zhucp]

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 int

SELECT @HeaderID=ID,@UserTypeID=UserTypeID FROM deleted

IF @UserTypeID = 2
BEGIN
DELETE FROM MsgClassBody WHERE HeaderID = @HeaderID
END

IF (@UserTypeID = 1) OR (@UserTypeID = 3)
BEGIN
DELETE FROM MsgStudBody WHERE HeaderID = @HeaderID
END

[JavaD]

有没有外键哦，有的化，建外键的时候，加上on delete cascade

[nxfbccu]

在触发器中判断是否为多笔删除:
if @@RowCount>1
begin
...
end;