痕迹

摘要： 当删除BG_Group表中的一条数据时，级联删除BG_Purview表中的若干条记录CREATE TRIGGER [dbo].[Del_Purview] ON [dbo].[BG_Group] AFTER DELETE AS IF @@ROWCOUNT = 0 RETURN DELETE FROM BG_Purview WHERE GroupID IN (SELECT GroupID FROM deleted) 阅读全文