这么简单得触发器错在那里????????????????????????
CREATE TRIGGER syn_dpt_delete ON dbo.depart
FOR UPDATE
AS
DELETE FROM S_SA a JOIN DELETED b ON b.depart_id = CAST(a.SA01 AS INT)
GO
--------
服务器: 消息 170,级别 15,状态 1,过程 syn_dpt_delete,行 4
第 4 行: 'a' 附近有语法错误。
作 用就是删除表