How to get values ​​from deleted record in MS SQL SERVER?

Question

SQL

There are three tables. Two of them are connected to the third one by means of foreign keys.
In the delete trigger, you need to somehow get the value of the primary key of the row being deleted in order to delete rows from the remaining two tables using this primary key. Actually, how to count values ​​from the deleted line?

Answer 1

In the trigger the deleted table contains deleted lines (I repeat "terms", but not one line). For example:

CREATE TRIGGER PersonDelete ON [Person] FOR DELETE AS 
BEGIN
  SET NOCOUNT ON 
  -- [dbo].[Variant]
  DELETE FROM Variant WHERE (Variant.Kind = 'P') AND (Variant.[Object] IN ( SELECT ID FROM deleted))
  -- [dbo].[Internet]
  DELETE FROM Internet WHERE (Internet.Kind = 'P') AND (Internet.[Object] IN ( SELECT ID FROM deleted))
END
--
GO

Or a connection like:

CREATE TRIGGER AttributeValueUpdateDelete ON FilmAttributeValue FOR UPDATE, DELETE AS 
BEGIN
  SET NOCOUNT ON 
  UPDATE FilmAttributeGroup 
    SET Uses = (SELECT COUNT(*) FROM FilmAttributeValue WHERE ([Group] = deleted.[Group]))
    FROM FilmAttributeGroup 
      INNER JOIN deleted ON FilmAttributeGroup.ID = deleted.[Group]
END
--
GO

Answer 2

https://stackoverflow.com/questions/6260688/how-do...