vendredi 30 janvier 2015

Update trigger in SQL after salary of employee has been changed - this records it to another table

I have a table like this:



empid | name | salary
1 | Jack | 25000
2 | Mary | 30000
3 | Jane | 40000
4 | Lary | 50000


I want to create a sql trigger that records the salary update into another seperate table accumlating whatever increase or decrease in the salary column of the employee table. Say if there was a single update for one specific salary column then it records this change however if there were mutiple changes to a salary column then it records all of it together into one column as well. All of this is recorded into a seperate table.


Aucun commentaire:

Enregistrer un commentaire