2
Reply

How to Create a Audit table

Deepak Ratan

Deepak Ratan

Jun 21 2015 11:01 PM
480
How to Create a Audit table for Insert, Update,Delete...?
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
 

Answers (2)