有关删除的触发器

Question

CREATE TRIGGER TB1_DEL
ON Table1
FOR DELETE 
AS
   delete from Table2,deleted where Table2.id = deleted.id
GO

Answer 1

CREATE TRIGGER [Table1_Delete] ON [dbo].[Table1] 
FOR  DELETE
AS
Begin
Delete from  Table2 Where id=(Select id from Deleted)
End

Answer 2

CREATE TRIGGER TB1_DEL
ON Table1
FOR DELETE 
AS
   delete Table2 from Table2,deleted where Table2.id = deleted.id
GO

Answer 3

掉了个GO，要加上CREATE TRIGGER [Table1_Delete] ON [dbo].[Table1] 
FOR  DELETE
AS
Begin
Delete from  Table2 Where id=(Select id from Deleted)
End
GO

Answer 4

alter TRIGGER trgtest
ON Table1
for delete
AS
BEGIN  
  delete from Table2 where Table2.id=(select id from deleted)
END
GO

Answer 5

GO
create trigger tr_table1_table2__del on table1 
for delete 
as
begin
 delete  from  table2  where id=(select id from Deleted)
 IF @@error !=0
 begin
    rollback tran
    return
 end
return
end
GO