CREATE TRIGGER new_trigger ON tbl AFTER UPDATE AS BEGIN UPDATE tbl SET col_time = GETDATE() WHERE col_pri IN (SELECT col_pri FROM inserted) END
ALTER TRIGGER new_trigger ON tbl AFTER UPDATE AS BEGIN UPDATE tbl SET col_time = GETDATE() WHERE col_pri IN (SELECT col_pri FROM inserted) END