trigger改为create trigger gu_tri
on gu
for delete
as
delete from gu where gu_name=(Select gu_name from Deleted)
return
on gu
for delete
as
delete from gu where gu_name=(Select gu_name from Deleted)
return
解决方案 »
- 急:sql server 2008 视图或者存储过程相关问题?
- 问一些sqlserver的基础知识,望各位朋友不吝赐教!
- CREATE TABLE 2EB0B250_tab(ID bigint, Name varchar(50), Pwd varchar(20));
- 查询一个表的某个字段与另一个表的某个字段不重复的数据?
- 求日期转化字符串的问题?
- acc数据库迁移到sql数据库出错,怎么解决
- 再问:這個SQL語句如何寫?(关于insert...select...语句的使用)
- 如何将另一台机器上MS SQL2000的数据库移到我的机器上?
- 在SQLSERVER中复制表结构如何将标识,主键等约束也复制!
- 如何截取时间段????
- 如何写这样的超级SQL 语句
- 120万数据分批导出成24个txt文件,每个5万条记录
我刚才通了下
这trigger设置只能删表gu中的合适项
on gu
for delete
as
delete from tu where gu_name=(Select gu_name from Deleted)
return
表gu的for delete 的触发器动作仍旧是删除表gu的记录?
On gu
for delete
As
delete from tu where gu_name in (Select gu_name from Deleted)
--用in,这样可以适用多条删除
最后是:
create trigger gu_tri
on gu
for delete
as
delete from tu where tu_name=(Select gu_name from Deleted)
return
以前老师讲课的时候没有好好听,后悔了
我执行:delete from gu
where gu_id='****' or gu_id='***'
语句的时候,怎么只删表tu的中的2条,而删表gu中一条(表tu、gu中符合where条件的各有2条)怎么回事
用in的是
create trigger gu_tri
On gu
for delete
As
delete from tu where tu_name in (Select gu_name from Deleted)再次谢谢