SQL Data History

Hi Guys,

I am still confused on how to create a database with the capability to store history data. I have observed that usual databases have a DateModified column. I want to understand how to have a data history in my database for auditing purposes. Do I need to create a separate table to copy all past data as a history data or archived data.

TransactionTable

Code:

---

TransactionID  TransactionDate    Items    Amount    DateModified

---

TransactionTableHistory

Code:

---

TransactionID    TransactionDate    Items    Amount    DateModified

---

Thank you for your help.