请教一条简单的触发器的写法 删除一张表的记录,同时删除其它几张表的相关的记录,怎么写?例如删除学生信息表里的一条学生记录,同时也要删除成绩表里的所有这个学生的记录。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 create trigger 触发器名 on studentafter deleteasbegin delete 成绩表 where id in (select id from deleted)end 假设两个表用id来关联create trigger tron table1 for delete asbegindelete from table2 where id=(select id from deleted)end create trigger 触发器名 on studentafter deleteasbegin delete 成绩表 where id in (select id from deleted) delete 课程表 where id in (select id from deleted)...end sql问题 请教存储过程,急等 如何将存储过程改写成函数 各位大哥请指点小弟,我想把原由的SQL 数据库文件备份那新的服务器上 sql简单问题 求救,请各位老师和同学帮忙优化一下SQL代码,最好加上注释 谢谢了 [100分]SQL的行组合成列的问题,急急急!!! 查询问题? sql 逗号后面 字符串截取 分组 安装时,提示"以前的某个程序安装已在安装计算机上创建挂起的文件操作,运行安装程序之前必须重新启动计算机",请问怎么解决? 怎样获得查询数据条数? 创建规则问题.
create trigger 触发器名 on student
after delete
as
begin
delete 成绩表
where id in (select id from deleted)
end
create trigger tr
on table1
for delete
as
begin
delete from table2 where id=(select id from deleted)
end
create trigger 触发器名 on student
after delete
as
begin
delete 成绩表
where id in (select id from deleted)
delete 课程表
where id in (select id from deleted)
...
end