Question

关于SQL触发器创建列名无效的问题

CREATE TRIGGER staff_delete ON worker
FOR DELETE
AS SELECT COUNT(*)
FROM deleted,depn,salary
WHERE depn.dep_num=deleted.dep_num AND salary.worker_num=deleted.worker_num
GO
执行时提示消息 207，级别 16，状态 1，过程 staff_delete，第 5 行
列名 'dep_num' 无效。
消息 207，级别 16，状态 1，过程 staff_delete，第 5 行
列名 'worker_num' 无效。
但是我的表中有dep_num和worker_num列

Answer 1

明显if (cWhCode = (SELECT cWhCode FROM Warehouse))
这句有问题，这句中第一个cWhCode列没有指明所在表，所以是无效的，
试试这句if ((select cWhCode from RdRecord01) = (SELECT cWhCode FROM Warehouse))

追问

大哥你是答非所问啊