CREATE TRIGGER autodetail
ON fixture
AFTER delete
AS
delete from matchdetails where matchdetails.id=deleted.id
GO
请问是怎么回事,请高手指教!!
...全文
673712打赏收藏
”无法绑定由多个部分组成的标识符“的问题
创建触发器如下,希望能够用deleted表来实现级联删除,可是执行提示错误说:消息 4104,级别 16,状态 1,过程 autodetail,第 5 行 无法绑定由多个部分组成的标识符 "deleted.id"。 CREATE TRIGGER autodetail ON fixture AFTER delete AS delete from matchdetails where matchdetails.id=deleted.id GO 请问是怎么回事,请高手指教!!