How to Create a Audit table

Question

How to Create a Audit table for Insert UpdateDelete...? For this Audit table how to write Trigger..? This is my Table Create table Cust CustID int PK PersonID int FK StoreID int FK TerritoryID int FK AccountNumber Computed varchar(10) rowguid Uniqueidentifier ModifiedDate datetime

Deepak Ratan · Answer

Hi sabyasachi mishra  I am new to SQL  Actually I have to use Audit_Table Concept for (  Insert and Update  ) According to my Cust Table How to implement?

Sabyasachi Mishra · Answer

Hi Deepak I didn't get your question. You have already created a Table Cust. Then what does the audit means for? Also which type of Trigger you want to Implement (DDL or DML). ---------------------------------------- Hope that helps. Please accept all the answers that helps you.