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

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

DROP TABLE SalesHistory

GO

CREATE TABLE SalesHistory

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

)

GO



INSERT INTO SalesHistory ( Product, SaleDate, SalePrice)                  

VALUES      

('Computer', DATEADD(mm, 55, '3/11/1919'), DATEPART(ms, GETDATE()) + (57) )

GO