利用trigger实现MSSQLServer2000时间戳功能

create table test(ID BIGINT PRIMARY KEY, update DATETIME);

Create Trigger TG_test On test After Update, insert As Update test Set update=GETDATE() from test a,inserted b where a.ID = b.ID;