Check out example codes for "mssql trigger examples". It will help you in understanding the concepts better.

Code Example 1

CREATE TRIGGER trigger_name   
ON { Table name or view name }   
[ WITH <Options> ]  
{ FOR | AFTER | INSTEAD OF }   
{ [INSERT], [UPDATE] , [DELETE] }

Learn ReactJs, React Native from akashmittal.com