插入的+删除的虚拟表行位置不匹配。
There is no match of inserted+deleted virtual table row positions.
不,您不能匹配行
一些选项:
- 还有另一个唯一不变的键(用于该更新)来链接行
- 限制为单行操作。
- 使用带有OUTPUT子句的存储过程来捕获键之前和之后
- 带有OUTPUT子句的INSTEAD OF触发器(TBH不确定是否可以这样做)
- 禁止主键更新(在注释后添加)
- there is another unique unchanging (for that update) key to link rows
- limit to single row actions.
- use a stored procedure with the OUTPUT clause to capture before and after keys
- INSTEAD OF trigger with OUTPUT clause (TBH not sure if you can do this)
- disallow primary key updates (added after comment)