Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mkfrns
Starting Member
2 Posts |
 Posted - 2013-12-09 : 12:17:22
|
| I have created audit tableCREATE TABLE Test_Audit(column_name varchar(50),old_value varchar(100),new_value varchar(100),Table_name varchar(100),Username varchar(100),action varchar(100),Audit_Timestamp datetime)and I have table named testingcreate table testing(number int, name varchar(10))I want trigger for insert,delete,update for table testing and the entries should be added to Test_Audit..I want the old values,new values,column name to be displayed in Audit table..My trigger only works with 1 column table.If i run for 2 column table,the latest modified column is updated in oldvalue and new value..but actually 2 values should get updated in oldvalue and new value for 2 columns table could anyone please help me with the queries??Your help is appreciated |
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
|
|
|
|
|
|
|
Triggers for insert,update,delete in SQL server