Триггер на удаление

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:      <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
CREATE TRIGGER <Schema_Name, sysname, Schema_Name>.<Trigger_Name, sysname, Trigger_Name> 
   ON  <Schema_Name, sysname, Schema_Name>.<Table_Name, sysname, Table_Name> 
   AFTER <Data_Modification_Statements, , INSERT,DELETE,UPDATE>
AS 
BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;
 
    -- Insert statements for trigger here
 
END
GO

CREATE TRIGGER [dbo].[DeleteStudent] 
   ON  [dbo].[Students]
   INSTEAD OF DELETE
AS 
 IF EXISTS(SELECT * FROM deleted)
BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;
DELETE C
  FROM deleted d
  JOIN dbo.Cars C ON d.[StudentID]=C.[StudentID]
  DELETE dbo.Students
  FROM deleted
  WHERE deleted.[StudentID]=Students.[StudentID];
    -- Insert statements for trigger here
 
END

CREATE TRIGGER [dbo].[DeleteStudent] 
   ON  [dbo].[Students]
   AFTER DELETE
AS 
 IF EXISTS(SELECT * FROM deleted)
BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;
 
  DELETE FROM dbo.Cars
  WHERE dbo.Cars.[StudentID] in (select studentsid from deleted);
    -- Insert statements for trigger here
 
END

 DELETE FROM dbo.Cars
  WHERE dbo.Cars.[StudentID] in (select studentid from deleted);