求触发器:同一个表内的Delete,谢谢,初学者。 create trigger tr_name on tableAfor deleteas delete a from tableA a join deleted b on a.folderid = b.id 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 create trigger tr_name on tableAfor deleteas delete a from tableA a join deleted b on a.folderid = b.id create trigger del_table on Afor deleteas delete from Awhere a.folderid = deleted.id 求执行一次就能插入十万条记录 事件探察器 如何过滤数据库 where id in (@s),这样的存储过程怎么写? 自定义函数问题:请问怎样在函数中求字符串表达式? 行列互换问题 Windows 2003 不支持MS-SQL2000吗????为什么我安装不上? 高手帮我看看OPENROWSET的用法错在那! sql与access之间导入导出重复数据,违反主键索引怎么解决?请楼上的高手赐教? 附加数据库出错,急求专家援助!!! 急呀!!!!!各位高手 如果在命令行下对SQL备份 如何获得当前的记录号(主建)
for delete
as
delete a
from tableA a
join deleted b on a.folderid = b.id
for delete
as
delete from A
where a.folderid = deleted.id