CREATE TRIGGER [TRIGGER_NAME] ON TableZhu FOR DELETE AS BEGIN DELETE FROM TablA WHERE ID = DELETEED.ID DELETE FROM TableB WHERE ID = DELETEED.ID DELETE FROM TableC WHERE ID = DELETEED.IDEND
--建立触发器: CREATE TRIGGER tri_tablezhu ON TableZhu FOR DELETE AS DELETE TablA from tablA a,deleted b WHERE a.ID = b.ID DELETE TableB from TableB a,deleted b WHERE a.ID = b.ID DELETE TableC from TableC a,deleted b WHERE a.ID = b.ID
--TRY create trigger tr_1 on TableZhu after delete as begin tran delete tablea from deleted where tablea.id=deleted.id delete tableb from deleted where tableb.id=deleted.id delete tablec from deleted where tablec.id=deleted.id if @@error=0 commit else rollback
FOR DELETE
AS
BEGIN DELETE FROM TablA WHERE ID = DELETEED.ID
DELETE FROM TableB WHERE ID = DELETEED.ID
DELETE FROM TableC WHERE ID = DELETEED.IDEND
--建立触发器:
CREATE TRIGGER tri_tablezhu ON TableZhu FOR DELETE
AS
DELETE TablA from tablA a,deleted b WHERE a.ID = b.ID
DELETE TableB from TableB a,deleted b WHERE a.ID = b.ID
DELETE TableC from TableC a,deleted b WHERE a.ID = b.ID
create trigger tr_1
on TableZhu
after delete
as
begin tran
delete tablea from deleted where tablea.id=deleted.id
delete tableb from deleted where tableb.id=deleted.id
delete tablec from deleted where tablec.id=deleted.id
if @@error=0
commit
else
rollback