weixin_38854800的博客

sqlserver触发器当表新增数据时生成新文件，监听文件变化，达到监听数据表变化添加触发器create trigger 触发器名称on 表名AfterinsertASBEGINDECLARE @cmd sysname, @var sysnameSET @var = rand()SET @cmd = ‘echo ’ + @var + ’ > d:\Today.txt’EXEC master…xp_cmdshell @cmdEND;–删除触发器drop trigger t