删除大类时,同时将小类删除,用事务处理如何写?有必要用吗? 可以写个触发器,也可以同时删除IDdelete from 表1 where id = 1delete from 表2 where id = 1 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 触发器CREATE TRIGGER [TRI_del] ON [a] FOR deleteASdetete b from deleted a,b b where a.关联=b.关联 我用CREATE TRIGGER [TRIG_del] ON [area] FOR DELETE ASdelete areasmall form deleted area,areasmall where area.area=areasmall.area提示from附近有语法错误 CREATE TRIGGER [TRIG_del] ON [area] FOR DELETE ASdelete areasmall form deleted a,areasmall bwhere a.area=b.area CREATE TRIGGER [TRIG_del] ON [area] FOR DELETE ASdelete areasmall form deleted a,areasmall b where a.area=b.area 改成CREATE TRIGGER [TRIG_del] ON [area] FOR DELETE ASdelete areasmall form deleted area a,areasmall b where a.area=b.area也不行 CREATE TRIGGER [TRIG_del] ON [area] FOR DELETE ASdelete areasmall from deleted a,areasmall b where a.area=b.area sql修改语句 求一比较难的SQL语句(无限级分类问题) 知道远程IP及数据库用户和口令,在企业管理器中能注册成功,为什么一直连接不上? 一个sql语句的写法 几种dsn的区别 SQL 判断输出图片 数据列表处理 行列转换 求助如何SQL语句中添加小计、合计 查询的问题,帮帮忙! 高分求教:如何在Sql語句中接收Sp_Lock返回的結果集? sqlserver导出txt文件的问题:Cannot use the output option when passing a constant to a stored procedure 向sql server2000 的库表中插入数据问题请教
CREATE TRIGGER [TRI_del] ON [a]
FOR delete
AS
detete b from deleted a,b b where a.关联=b.关联
CREATE TRIGGER [TRIG_del] ON [area]
FOR DELETE
AS
delete areasmall form deleted area,areasmall where area.area=areasmall.area提示from附近有语法错误
FOR DELETE
AS
delete areasmall form deleted a,areasmall bwhere a.area=b.area
FOR DELETE
AS
delete areasmall form deleted a,areasmall b where a.area=b.area
CREATE TRIGGER [TRIG_del] ON [area]
FOR DELETE
AS
delete areasmall form deleted area a,areasmall b where a.area=b.area
也不行
FOR DELETE
AS
delete areasmall from deleted a,areasmall b where a.area=b.area