sql 触发器更新时间问题？

大概这样，加一点错误处理保险一点CREATE TABLE test (id INT ,updatetime DATETIME)
INSERT INTO test values(1,GETDATE())
go
ALTER TRIGGER tr_Test ON test FOR UPDATE
AS
UPDATE test
SET updatetime=GETDATE()
FROM inserted
WHERE test.id=inserted.idgo
SELECT * FROM test
GO
UPDATE test SET id=2
SELECT * FROM test