create trigger tr_TableName_insert
on TableName for insert
as
Declare @ID INT
Declare @X INT
Declare @Y INT
Declare @Z INT
Declare @TM DateTIME
select @id=id,
@X=X,
@Y=y,
@Z=Z,
@TM=TM
from inserted
IF Not Exists(Select ID FROM B Where ID=@ID)
BEGIN
Insert INTO B
Values(@ID,@X,@Y,@Z,@TM)
END
ELSE
BEGIN
Update B
Set X=@X,
Y=@Y,
Z=@Z,
TM=@TM
Where ID=@ID
END
on TableName for insert
as
Declare @ID INT
Declare @X INT
Declare @Y INT
Declare @Z INT
Declare @TM DateTIME
select @id=id,
@X=X,
@Y=y,
@Z=Z,
@TM=TM
from inserted
IF Not Exists(Select ID FROM B Where ID=@ID)
BEGIN
Insert INTO B
Values(@ID,@X,@Y,@Z,@TM)
END
ELSE
BEGIN
Update B
Set X=@X,
Y=@Y,
Z=@Z,
TM=@TM
Where ID=@ID
END
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货