这个存储过程怎么写？

[skyyjl]

有两个表
create table NEWSClass(classId int NOT NULL,
content varchar(20) NOT NULL,
primary key(classId),
);

create table NEWSKind(kindId int NOT NULL,
content varchar(255) NOT NULL,
classId int references NEWSClass(classId),
primary key(kindId),
);

请问我删除newsclass表的时候对应的在newskind表中classId对应的kindId也删除掉

[azsoft]

create proc del_NEWSKind @classId varchar(20) as
delete from NEWSKind join NEWSClass on kindId=@classId
where kindId=@classId

exec del_NEWSKind @classId=classId

[azsoft]

or:

用触发器

[zjcxc]

--这个应该用触发器.
create trigger t_delete on newsclass
for delete
as
delete from NEWSKind where classId in(select classId from deleted)
go