创建触发器

1.Oracle 触发器

CREATE OR REPLACE TRIGGER TG_MTL_B_U_PACKINFO BEFORE update or insert
ON t_state
FOR EACH row
begin
 --if nvl(:new.item_po_no,'/') != nvl(:old.item_po_no,'/')  then
    :new.lastupdatedate := sysdate;
 --end if;
end;

2.MS SQL Server  触发器

USE [dbH]
GO
/****** 对象:  Trigger [trgUpdateDate]    脚本日期: 03/01/2012 11:20:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- ======================