| dEmployee | Mar 19 2009 9:10PM | Mar 19 2009 9:10PM | Instead of Delete | Employee | INSTEAD OF DELETE trigger which keeps Employees from being deleted.
|
| iuPerson | Mar 19 2009 9:10PM | Mar 19 2009 9:10PM | After Update Insert | Person | AFTER INSERT, UPDATE trigger inserting Individual only if the Customer does not exist in the Store table and setting the ModifiedDate column in the Person table to the current date.
|
| iWorkOrder | Mar 19 2009 9:10PM | Mar 19 2009 9:10PM | After Insert | WorkOrder | AFTER INSERT trigger that inserts a row in the TransactionHistory table. Yay!
|
| uWorkOrder | Mar 19 2009 9:10PM | Mar 19 2009 9:10PM | After Update | WorkOrder | AFTER UPDATE trigger that inserts a row in the TransactionHistory table, updates ModifiedDate in the WorkOrder table.
|
| iPurchaseOrderDetail | Mar 19 2009 9:10PM | Mar 19 2009 9:10PM | After Insert | PurchaseOrderDetail | AFTER INSERT trigger that inserts a row in the TransactionHistory table and updates the PurchaseOrderHeader.SubTotal column.
|
| uPurchaseOrderDetail | Mar 19 2009 9:10PM | Mar 19 2009 9:10PM | After Update | PurchaseOrderDetail | AFTER UPDATE trigger that inserts a row in the TransactionHistory table, updates ModifiedDate in PurchaseOrderDetail and updates the PurchaseOrderHeader.SubTotal column.
|
| uPurchaseOrderHeader | Mar 19 2009 9:10PM | Mar 19 2009 9:10PM | After Update | PurchaseOrderHeader | AFTER UPDATE trigger that updates the RevisionNumber and ModifiedDate columns in the PurchaseOrderHeader table.
|
| dVendor | Mar 19 2009 9:10PM | Mar 19 2009 9:10PM | Instead of Delete | Vendor | INSTEAD OF DELETE trigger which keeps Vendors from being deleted.
|
| iduSalesOrderDetail | Mar 19 2009 9:10PM | Mar 19 2009 9:10PM | After Update Delete Insert | SalesOrderDetail | AFTER INSERT, DELETE, UPDATE trigger that inserts a row in the TransactionHistory table, updates ModifiedDate in SalesOrderDetail and updates the SalesOrderHeader.SubTotal column.
|
| uSalesOrderHeader | Mar 19 2009 9:10PM | Mar 19 2009 9:10PM | After Update | SalesOrderHeader | AFTER UPDATE trigger that updates the RevisionNumber and ModifiedDate columns in the SalesOrderHeader table.Updates the SalesYTD column in the SalesPerson and SalesTerritory tables.
|