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
--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 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