I m trying to create a basic database trigger that conditionally deletes rows from database1 table1 when a row from database2 table2 is deleted I m new to triggers and was hoping to learn the best way to accomplish this This is what I have so far Suggestions CREATE TRIGGER sampleTrigger ON database1 dbo table1 FOR DELETE AS IF EXISTS SELECT foo FROM database2 dbo table2 WHERE id deleted id AND bar 4 -- If there is a row that exists in database2 dbo table2 -- matching the id of the deleted row and bar 4 delete -- it as well -- DELETE STATEMENT GO

SQL Server ON DELETE Trigger

The Solution to SQL Server ON DELETE Trigger is

CREATE TRIGGER sampleTrigger
    ON database1.dbo.table1
    FOR DELETE
AS
    DELETE FROM database2.dbo.table2
    WHERE bar = 4 AND ID IN(SELECT deleted.id FROM deleted)
GO

~ Answered on 2012-04-03 15:54:34

SQL Server ON DELETE Trigger

The Solution to SQL Server ON DELETE Trigger is

Most Viewed Questions: