About SQL Advance Features
Stored Procedures are block of codes with different SQL statement which can be reused again and again in SQL Server. It means, a stored procedure is a prepared SQL statements or codes that can be saved, so we can reuse the code again.
A trigger is a special stored procedure which runs automatically when an event occurs in the database in SQL server. There are three types of triggers which are DDL, DML and Logon trigger. Trigger is executed on different SQL statements which are INSERT, UPDATE or DELETE.