触发器 急急急急急!!!!!!!!!!!!!!!!!!!!!!! create trigger tri_delete on Provincefor deleteasdelete from City a ,deleted d where a.p_id = d.idgo 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 更安全的触发器:create trigger tri_delete on Provincefor deleteasbegin transactiondelete from City a ,deleted d where a.p_id = d.idif @@error > 0begin raiserror('Can not delete from City!',16,1) rollback returnendcommit transactiongo a cascade delete foreign key is ok 求助。。。sql查询带有namespace的xml的几个问题。。。 问一个关于SQL分组查询的问题? 一个困扰了我好久的sql问题 SQL2005 通过查询一个表的字段,查询另一个表的不同字段 sql server连接问题,在线等... 如何获取数据库所有表的信息(字段类型) 一時想不出 这条语句哪里错了?谢谢大家帮看看!!!! 求查询增加速度的解决方案??? hql联合查询 请教如何更改syscolumns系统表字段类型 求解一条插入新纪录的语句!
create trigger tri_delete on Province
for delete
as
begin transaction
delete from City a ,deleted d where a.p_id = d.id
if @@error > 0
begin
raiserror('Can not delete from City!',16,1)
rollback
return
end
commit transaction
go