利用SQL Server 2005 COLUMNS_UPDATED函数进行数据审计

IF OBJECT_ID('SalesHistoryAudit','U') > 0      

DROP TABLE SalesHistoryAudit

GO

CREATE TABLE SalesHistoryAudit

(            
      AuditID INT IDENTITY(1,1),
      SaleID INT,            
      Product VARCHAR(30) NOT NULL,             
      SaleDate DATETIME,             
      SalePrice MONEY, 
      ColumnsUpdated XML NULL

)

GO