create trigger for insert and update in sql server code example
Example: mssql trigger examples
CREATE TRIGGER trigger_name
ON { Table name or view name }
[ WITH <Options> ]
{ FOR | AFTER | INSTEAD OF }
{ [INSERT], [UPDATE] , [DELETE] }
CREATE TRIGGER trigger_name
ON { Table name or view name }
[ WITH <Options> ]
{ FOR | AFTER | INSTEAD OF }
{ [INSERT], [UPDATE] , [DELETE] }