利用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;