CREATE TRIGGER chu3
ON 员工考勤
AFTER INSERT
AS
if((select 上班考勤 from inserted)='Y')
BEGIN update 员工津贴 set 上班天数=上班天数+1 where 员工号=(select 员工号 from inserted)
END
只能在员工考勤里添加一列,在插入一列就报错,说子查询结果不唯一,估计就是select 上班考勤 from inserted 的问题,,,,,,,,,关键怎么改
ON 员工考勤
AFTER INSERT
AS
if((select 上班考勤 from inserted)='Y')
BEGIN update 员工津贴 set 上班天数=上班天数+1 where 员工号=(select 员工号 from inserted)
END
只能在员工考勤里添加一列,在插入一列就报错,说子查询结果不唯一,估计就是select 上班考勤 from inserted 的问题,,,,,,,,,关键怎么改
ON 员工考勤
AFTER INSERT
AS
BEGIN
update 员工津贴 set 上班天数=上班天数+1
where 员工号 in (select 员工号 from inserted where 上班考勤='Y')
END
set 上班天数=上班天数+1
where 员工号 in (select 员工号 from inserted where 上班考勤='Y')
ON 员工考勤
AFTER INSERT
AS
BEGIN
update 员工津贴 set 上班天数=员工津贴.上班天数+1
from inserted i
where 员工津贴.员工号 = i.员工号
and i.上班考勤='Y'
END