数据库是sql2000
下面是创建的两个表
CREATE TABLE Depts
(
DeptNo CHAR(4) PRIMARY KEY,
DeptName CHAR(20),
);CREATE TABLE Students
(
Sno CHAR(10) PRIMARY KEY,
Sname CHAR(16),
DeptNo CHAR(4),
StartDate DATETIME,
CreditHours INT,
CONSTRAINT Student_dept FOREIGN KEY(DeptNo) REFERENCES Depts,
);我想要创建一个触发器,使我删除Depts的记录时,同时删除Students中的相应DeptNo的记录
我写了一个
CREATE TRIGGER del_dept_stu ON dbo.Depts
FOR DELETE
AS
delete from Students where Students.DeptNo in (select DeptNo from deleted)
不过没起作用
请问,到底应该怎么写啊
下面是创建的两个表
CREATE TABLE Depts
(
DeptNo CHAR(4) PRIMARY KEY,
DeptName CHAR(20),
);CREATE TABLE Students
(
Sno CHAR(10) PRIMARY KEY,
Sname CHAR(16),
DeptNo CHAR(4),
StartDate DATETIME,
CreditHours INT,
CONSTRAINT Student_dept FOREIGN KEY(DeptNo) REFERENCES Depts,
);我想要创建一个触发器,使我删除Depts的记录时,同时删除Students中的相应DeptNo的记录
我写了一个
CREATE TRIGGER del_dept_stu ON dbo.Depts
FOR DELETE
AS
delete from Students where Students.DeptNo in (select DeptNo from deleted)
不过没起作用
请问,到底应该怎么写啊
解决方案 »
- getHibernateTemplate() 问题
- oracle下可以用set linesize XX来控制一条数据一行显示,那mysql呢
- 请教JS问题
- 哪位高手知道如何做个网页像QQ空间一样(jsp)
- 关于jsp中使用html:form中action="mailto"的问题
- 邮件服务器Imail问题!基于JAVAMAIL,发邮件时出Could not connect to SMTP host: localhost, port: 25
- 还是乱码问题,为什么这样也是会出乱码呀?
- 初学RichFaces,遇到很麻烦问题,需要请教
- 散粉...
- 我的tomcat5怎么也启动不起来,
- JSP转换成Servlet之后???
- 大家一起砸电脑,天天对着电脑活受罪!
FOR DELETE
AS
declare @deptno char(4)
begin
select @deptno = DeptNo from deleted
delete from Students where DeptNo = @deptno
end
go
FOR DELETE
AS
delete from Students where Students.DeptNo =deleted.DeptNo
FOR DELETE
AS
declare @DpNo char(4)
select @DpNo=DeptNo from deleteddelete from Students
where DeptNo=@DpNo