使用存储过程,先删除从表记录,然后再删除主表相关联记录
但是我使用的是两条DELETE语句,大家帮助我看看怎么样合成一条SQL语句
create procedure Ownn_CourseDel-----------删除课程
(
@TeacherID varchar(50),
@CourseID int
)
as
delete from Ownn_CourseResourceInfo where CourseID=@CourseID and TeacherID=@TeacherID
delete from Ownn_CourseInfo where [ID]=@CourseID and TeacherID=@TeacherID
但是我使用的是两条DELETE语句,大家帮助我看看怎么样合成一条SQL语句
create procedure Ownn_CourseDel-----------删除课程
(
@TeacherID varchar(50),
@CourseID int
)
as
delete from Ownn_CourseResourceInfo where CourseID=@CourseID and TeacherID=@TeacherID
delete from Ownn_CourseInfo where [ID]=@CourseID and TeacherID=@TeacherID
删除从表数据成功后 改变 Boolean 值 为true
然后判断 如果 Boolean 值 为 true
执行删除主表记录sql