Tim Mackey's Weblog

i always found the syntax of SQL triggers very difficult to remember, so i'm just posting a sample one here.  it performs a cascade delete on a table that doesn't have referential integrity (because there are 2 potential foreign keys).

ALTER TRIGGER [dbo].[Table1CascadeDeleteTable2]
   ON  [dbo].[Table1]
   FOR DELETE
AS 
BEGIN
	declare @Ref int;
	SELECT @Ref = Ref FROM Deleted;
	delete from Table2 where Ref = @Ref;
END