为甚么,我对学生进行删除操作时,其他表中的信息被删掉了,偏偏StudentInformation中的删不到,请高手解答一下
CREATE TRIGGER Delete_Student ---------删除一个学生信息,同时删除,StudentCourse,FamilyInformation,Evaluation中含所删StudentID的行
ON StudentInformation----学生信息表
INSTEAD OF DELETE
AS
DELETE f FROM FamilyInformation f,Deleted d
WHERE f.StudentID=d.StudentID
DELETE s FROM StudentCourse s,Deleted d
WHERE s.StudentID=d.StudentID
DELETE e FROM Evaluation e,Deleted d
WHERE e.StudentID=d.StudentID
CREATE TRIGGER Delete_Student ---------删除一个学生信息,同时删除,StudentCourse,FamilyInformation,Evaluation中含所删StudentID的行
ON StudentInformation----学生信息表
INSTEAD OF DELETE
AS
DELETE f FROM FamilyInformation f,Deleted d
WHERE f.StudentID=d.StudentID
DELETE s FROM StudentCourse s,Deleted d
WHERE s.StudentID=d.StudentID
DELETE e FROM Evaluation e,Deleted d
WHERE e.StudentID=d.StudentID
解决方案 »
- 求"Microsoft SQL Server 2005技术内幕"系列丛书。。
- 在sql server2000中如何将一个文件以二进制形式保存到数据库中
- 请教
- 存储过程在查询分析器执行正确,用ADO.COMMAND对象就不行了
- 用vb 连接远程win2003上的sql server 连接不上,提示一般性网络错误,怎么解决呢?
- full join 中的排序问题,急啊
- 请问C/S结构中,用什么方法写C端的程序操作数据库最快?
- 在sqlserver里,数据类型text和char有什么区别?5分请笑纳
- 高分救命:SQL Server 2000 分布式事务处理的问题
- sql语句
- sql2000中except语法错误
- 看以下功能可用触发器实现吗,谢谢
CREATE TRIGGER Delete_Student ---------删除一个学生信息,同时删除,StudentCourse,FamilyInformation,Evaluation中含所删StudentID的行
ON StudentInformation----学生信息表
FOR DELETE
AS
DELETE f FROM FamilyInformation f,Deleted d
WHERE f.StudentID=d.StudentID
DELETE s FROM StudentCourse s,Deleted d
WHERE s.StudentID=d.StudentID
DELETE e FROM Evaluation e,Deleted d
WHERE e.StudentID=d.StudentID
调一下顺序,把外键所在表的数据先删除试试
所以要想删StudentInformation中的某一行,必须将StudentCourse,FamilyInformation,Evaluation中对应的行删掉,
否则会出现异常,所以不能用For
To 2楼:我就是这样做的,但是偏偏删不到,是不是还要再在最后添加一句删除StudentInformation的SQL语句