关于数据库约束问题 一个学生表、一个成绩表、都分别有主外键,当学生退学时,要删除这个学生。如果在学生表中要删除学生并且将学生所有信息都删掉,怎么做,给点思路? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 触发器 create trigger tr_student on studentfor deleteasbegin delete from score , deleted where score.studentid=deleted.studentidend create trigger tr_student on studentfor deleteasbegin delete score from score , deleted where score.studentid=deleted.studentidend 求一条简单的sql语句 数据日志如何恢复 求SQL语句? 安装SQL2008报错 TSQL下的存贮过程 请叫邹大哥及各位前辈(系统掉电导致SQL2005数据库基于一致性的逻辑 I/O 错误) 数据库连接问题!难啊!愁! 疑难杂症 一个SQL查询 想死我了 行列转换 mysql中x为什么不能做基本表的表名? 求助:如何实现三个表的全连接查询? 求SQL高手帮忙
for delete
as
begin
delete from score , deleted where score.studentid=deleted.studentidend
for delete
as
begin
delete score from score , deleted where score.studentid=deleted.studentidend