if exists (select * from sysobjects where name = 'proc_stu') drop proc proc_stu go create proc proc_stu @writtenPass int = 60,----输入参数,笔试及格线 @LabPass int = 60 ---- 输入参数,机试及格线 as print '参加本次考试没有通过的学员' select stuinfo.stuName,stuinfo.stuNo ,stuMarks.writtenExam,stuMarks.LabExam from stuinfo inner join stuMarks on stuMarks.stuNo=stuinfo.stuNo where writtenExam<@writtenPass or LabExam<@LabPass
exec proc_stu 70,80