CREATE TRIGGER TG_PSS ON MF_PSS
FOR INSERT ,update
AS
begin
用 COLUMNS_UPDATED() 或update()判断更新的列 then
insert into tg_temp(tg_no,bz)
select ps_no,'插入记录' from INSERTED
end
看看联机帮助的例子,很简单的
FOR INSERT ,update
AS
begin
用 COLUMNS_UPDATED() 或update()判断更新的列 then
insert into tg_temp(tg_no,bz)
select ps_no,'插入记录' from INSERTED
end
看看联机帮助的例子,很简单的
FOR INSERT,update
AS
begin
insert into tg_temp(tg_no,bz)
select ps_no,'插入记录' from INSERTED and ps_no not in (select ps_no from deleted)insert into tg_temp(tg_no,bz)
select ps_no,'修改记录' from INSERTED and ps_no in (select ps_no from deleted)insert into tg_temp(tg_no,bz)
select ps_no,'删除记录' from deleted and ps_no in (select ps_no from insteted)
end
FOR INSERT,update,delete
AS
begin
insert into tg_temp(tg_no,bz)
select ps_no,'插入记录' from INSERTED and ps_no not in (select ps_no from deleted)insert into tg_temp(tg_no,bz)
select ps_no,'修改记录' from INSERTED and ps_no in (select ps_no from deleted)insert into tg_temp(tg_no,bz)
select ps_no,'删除记录' from deleted and ps_no in (select ps_no from insteted)
end
select ps_no,'删除记录' from deleted and ps_no not in (select ps_no from insteted)