作者ruby0104 (:))
看板Database
标题Re: [SQL ] Trigger写法？
时间Thu Jul 17 01:00:21 2008
CREATE TRIGGER TriA on Table_A
for update
AS
insert into Table_B
select pc[],gettime[]
from inserted
ID[] 必须是identity column才行
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 71.132.194.26
※ 编辑: ruby0104 来自: 71.132.194.26 (07/17 16:25)