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.