create trigger mytrigger on [dbo].[kclient]
for insert,update
as
-----判斷記錄是否存在,如果存在則刪除.再插入否則只須做插入動作便可.
if exists(select * from kclient_tc where client_bh in(select kcode form inserted))
begin
delete kclient_tc where client_bh in(select kcode from inserted)
insert into kclient values(有幾個字段就多少個值)
end
else
begin
insert into kclient values(有幾個字段就多少個值)
end
試一試吧希望能幫上你的忙.
CREATE TRIGGER tr_kclient_ins ON [dbo].[kclient ]
FOR INSERT
AS
declare @kcode as string
select @kcode=kcode from inserted
delete from kclient_tc where client_bh =@kcode
CREATE TRIGGER mytrigger ON [dbo].[KCLIENT]
FOR INSERT,UPDATE
AS
IF EXISTS(SELECT * FROM KCLIENT_TC WHERE CLIENT_BH IN(SELECT KCODE FROM INSERTED))
DELETE KCLIENT_TC WHERE CLIENT_BH IN(SELECT KCODE FROM INSERDED)
create trigger mytrigger on kclient for
insert,update
as
if exists(select * from kmain.kclient_tc where kmain.kclient_tc.client_bh=kmain.kclient.kcode)
delete kmain.kclient_tc where kmain.client_tc.client_bh=kmain.kclient.kcode
CREATE TRIGGER tr_kclient_ins ON [dbo].[kclient ]
FOR INSERT
AS
delete from kclient_tc where client_bh in(select kcode from inserted)
delete from kclient where kcode _bh in(select kcode from inserted)
insert into kclient
select * from inserted