Difference between For/After Trigger and Instead Trigger in SQL Server

For/After Trigger:-

• It executed after constraints checked.
• These triggers can be created only on Tables.
• These triggers can be executed for multiple operations

Instead Trigger:-

• It executraes just before a constraints are checked.
• These triggers can be created Tables as well as Views.
• These triggers can be executed for single operations.