When we use trigger in SQL Server

Question

Hi all When we use trigger in SQL Server ?

DOTNET Developer · Answer

Triggers are used when you need to execute a certain action as a result of an INSERT UPDATE or DELETE. Data manipulation code should be executed using stored procedures. One such similar situation where I used trigger is: When the value of Column A is updated in Table A which is placed in say database X you need to update the value of Column B in Table B which is placed in database Y.