![]() |
#2
cnfarer2010-12-27 14:30
|
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