updatecache.sql

asp.net技术内幕的书配源码

CREATE TRIGGER UpdateCache
ON Products
FOR UPDATE, DELETE, INSERT
AS
DECLARE @cmd Varchar( 200 )
SELECT @cmd = 'echo ' + Cast( getDATE() As Varchar( 50 ) ) +
  ' > c:\tableChange.txt'
EXEC master..xp_cmdshell @cmd, no_output