SQL Server Dataload from Import to Actual Table and record the same information in another table(reference)

See more:

SQL

server

Hi All

I want to load data from a Impot table(say. Student_Import) to actual table (say . Student).

The process should like happen this "Whenever a row is inserted or updated from Import to Actual , the system should record them in a Audit table (say Audit(table_name,action,Comments,Date) and the inserted values should come under Comment Column of Audit table like (Name=Ajay ,Section = B Course = SQL)."

A Record is updated when a match is found as per the StudentID column in both tables (Import as well as Actual table) else it should be inserted ."

both insert and update should record the changes into table Audit

For Update ,the Comment Column of Audit table should store the after and before values for all columns that are being changed .

Thanks in advance.