i have one doubt for sql(trigger)

Question

Create student history table

so whenever update or insert record in student table its marks in this table

table structure

id

StudentID (id of student table)

ColumnName

OldValue

NewValue

UpdatedDatetime

please create trigger for this

 

iam already created for studenthistory table insert update record also over my doubt is how to create a trigger for this (ie) i want to show history for student table whatever changes are done in student table should be shown in table anyone please help me 

 

hi anybody is there please rectify my problem