T-SQL编程（带输入参数的存储过程）

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