sql 变量

declare @c_no char(8)
SET @c_no = '015932'
select S.sno 学号,sname 姓名,sex 性别,birthday 出生日期,school_year 级别,S.class 班级 
from Student S where S.sno in 
(select sno from select_course where course_no=@c_no)