sqlserver触发器
当表新增数据时生成新文件,监听文件变化,达到监听数据表变化
添加触发器
create trigger 触发器名称
on 表名
After
insert
AS
BEGIN
DECLARE @cmd sysname, @var sysname
SET @var = rand()
SET @cmd = ‘echo ’ + @var + ’ > d:\Today.txt’
EXEC master…xp_cmdshell @cmd
END
;
–删除触发器
drop trigger trigger_name;
–搜索触发器
select * from sysobjects where xtype=‘TR’;
–插入
insert into DCS_AOI(LineName,MachineName,SetupName,PCBCode,CreateTime,Result,Remark) VALUES(‘1’,‘1’,‘1’,‘1’,null,‘1’,‘1’)