ALTER TRIGGER [dbo].[trig_InsertInfo] on [dbo].[talk]
FOR insert
AS
if exists(select id from inserted where id in(select id from talk))
begin
update talk set talkabout=(select talkabout from inserted) where id=(select id from inserted)
end
else
begin
insert into talk(id,talkabout)
select id,talkabout from inserted
end

这是主动数据库研究的内容。真正的主动数据库还没有！