Introduction to stored procedures and triggers in SQL Server.
https://docs.microsoft.com/en-us/sql/relational-databases/stored-procedures/create-a-stored-procedure?view=sql-server-ver15
https://www.sqlservertutorial.net/sql-server-triggers/