--try
CREATE TRIGGER aaa_Change ON A
FOR UPDATE
AS
IF UPDATE (No)
BEGIN
DECLARE @myID as VARCHAR(100)
SELECT @myID = ID FROM inserted insert
into B(ID)
values (@myID)
END
CREATE TRIGGER aaa_Change ON A
FOR UPDATE
AS
IF UPDATE (No)
BEGIN
DECLARE @myID as VARCHAR(100)
SELECT @myID = ID FROM inserted insert
into B(ID)
values (@myID)
END
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货