Sql Server删除触发器示例

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE TRIGGER sdictuser.trg_PermitInfo
   ON sdictuser.tb_PermitInfo
   AFTER DELETE
AS
BEGIN

 SET NOCOUNT ON;

 DELETE FROM ssd.sduser.tb_user
  WHERE lgname = (SELECT struserid FROM deleted)

END
GO