--Cost:wht
--Select a single sheet
CREATE PROCEDURE sp_student_selectAsId
@stuId varchar(15)
AS
BEGIN
select stuId,
stuName,
stuSex= case stuSex when '0' then '男' else '女' end ,
stuStatus=case stuStatus when '0' then '没有考试' when '1' then'考试中' when '2' then '已考试' end,
stuPwd
from student
where stuId=@stuId