sq_checkpass.sql

思燕大学成绩查询系统 具有很高的参考价值 大家可以看一看

CREATE PROCEDURE sp_CheckPass

        @CHKName VARCHAR(30),
        @CHKPass VARCHAR(70)
AS

SELECT [student_id],[student_no],[student_pass],[student_name],[department_id],[teacher_id],[class_id] 

FROM student

WHERE student_no=@CHKName AND student_pass=@CHKPass

go