sq_checkpass.sql

来自「eayanQuery思燕大学成绩查询系统 版本 V1.6」· SQL 代码 · 共 13 行

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