Auditing two different tables in SQL Server

Question

I have a form with data. Any changes or insertion, this data should be updated when towing various tables, such as name, salary in one table and address, mail identifier in another table.

As in the example above, I have several columns in both tables.

Now I want to audit the table. So I think I need to create a view for two tables and set up a trigger for the view. Is it correct?.

And also I need to know only the affected columns. How to get only the affected columns?

Please offer me a solution.

Thank!!

Answer 1

- SQL Server:

• SQL Server ( SQL Server 2008)

• SQL Server

• SQL Server ( SQL Server 2008 R2)

• SQL Server ( )

, - : SQL Server.

"":

• Inserted - , ( INSERT) ( UPDATE)
• Deleted - , ( DELETE) ( UPDATE)

- , .