MSSQLÖÐÓô¥·¢Æ÷Éú³ÉÈÕÆÚ

±í:smalltype
×ֶΣºID(int)£¬time(datetime)
ÎÒÏëÔÚвåÈëÒ»ÌõÐÅÏ¢ºó£¬ÔÚdatetimeÄÚÉú³Éµ±Ç°µÄ²åÈëÈÕÆÚ£¬ÎÒÏëÓô¥·¢Æ÷ʵÏÖÕâ¸ö¹¦ÄÜ
È磺вåÈë
    ID=4ºó£¬timeµÄÖµ±äΪ£¨time="2009-12-27 12:20:35"£©
´¥·¢Æ÷Ó¦¸ÃÔõôд£¿£¿£¿£¿

---

SQL code:
insert into tb valus(4,getdate())

¿ÉÒÔÓÃÉèÖÃĬÈÏÖµµÄ·½·¨ÊµÏÖ

alter table tb
alter column time datetime getdate()

---

SQL code:
create trigger insertdate on smalltype
for insert
as
begin
update smalltype set time=getdate()
where ID=(select ID from inserted)
end

---

SQL codecreate table smalltype(ID int , time datetime)
go

create trigger my_trig on smalltype for insert
as
  update smalltype set time = getdate() where id = (select id from inserted)
go

insert into smalltype (id) values(1)
insert into smalltype (id) values(2)

select * from smalltype

drop table smalltype