[求助]触发器
各位高手:请帮我改一下以下代码:
CREATE TRIGGER pos_chan ON [dbo].[position_change]
FOR INSERT
AS
update staff,inserted set depart_name=inserted.later_depart,
position_name=inserted.later_pos where staff.staff_name=
inserted.staff_name and staff.depart_name=inserted.former_depart
and staff.position_name=inserted.former_pos
错误提示:第四行","附近有语法错误