CREATE TRIGGER tr_insert
ON EMP
FOR UPDATE
AS
IF UPDATE ( TITLE) begin
update A
set A.BASEPAY=A.BASEPAY+150
from SALARY A
inner join inserted B on B.ENO=A.ENO
where B.TITLE='工程师'
END
GOgo
ON EMP
FOR UPDATE
AS
IF UPDATE ( TITLE) begin
update A
set A.BASEPAY=A.BASEPAY+150
from SALARY A
inner join inserted B on B.ENO=A.ENO
where B.TITLE='工程师'
END
GOgo
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货