Create Trigger trg_Delete
On A
For Delete
As
Delete B where B.章节码 in (select 章节码 from Deleted)
Return
On A
For Delete
As
Delete B where B.章节码 in (select 章节码 from Deleted)
Return
解决方案 »
- 求一个sql语句
- SQL中有没有这样的包含函数~
- 還原指定文件夾下的備份文件_SQL2005为例
- SqlServer2005 分布式事务处理 和 跨多个数据库服务器数据处理方法
- 如何把数据库中的数据都去掉前后的空格阿?不然不好直接使用数据库中的数据阿。
- 根据表中某字段的编码规则更新表中另一字段的值?晕了!
- 当 IDENTITY_INSERT 设置为 ON 或某个复制用户向 NOT FOR REPLICATION 标识列中插入内容时,必须为表 't2' 中的标识
- SQL2005備份的資料不能在SQL2000恢復可能存在的原因?
- 关于UPDATE的小问题,大家帮忙!
- SQL2000无法启动?
- 关于触发器的问题,高分求助!!!!
- 手头没书,求简单SQL,在线等!
On A
For Delete
As
Delete
From B
Where B.章节码 in(select 章节码 from Deleted)
On A
For Delete
As
begin
Delete
From B,Deleted
Where B.章节码 = Deleted.章节码
end
On A
For Delete
As
delete B from B, DELETED c where B.章节码 = c.章节码
Return
On A
For Delete
As
delete B from B, DELETED c where B.章节码 = c.章节码
Return