Application of SQL Server Trigger in Tracks Reservation
Jingwen Huang · Computer Technology and Development · 2007
In this paper,for easy to protect and monitor important data,propose a method that trigger was applied to achieve the goal of tracks reservation.Via designing a special redundant table in database which can record the data modification tracts,whenever data change,the trigger can write a former data backup into this redundant table automatically.Since it is a relational record set,it is convenient to query or select,and to realize a series of UNDO backdating and data rescue.Experimental results and the practice show that this method is available and well effective.