I am using SQL SERVER 2005.
I know how to write a trigger for a basic insert or update or delete. But here in my case I have to use
the below condition and create a trigger.
I havent used any trigger till now in my job. So I am facing a slight problem in understanding and writing the code.....
I got the following requirement to create a new trigger for the following scenario :
The user (john) should be notified when the following happens :
Any transaction entered to account 100 which is not a ABN,CCH,or TTW
Any transaction entered to account 189 which is not a KHD
Description of fields :
100 and 189 are values for AccountCode Column in Account Table
ABN,CCH,TTW and KHD are values for CompanyTypeCode Column in Company Table.
I need to create new trigger on DLT_Data table
View Complete Post