select paper.PaperID,paper.PaperName,ScoreType,PaperType=case PaperType when 0 then '手动选择试题' when 1 then '随机生成试题' end,
IsActived = case IsActived when 0 then '未激活' else '激活' end,CreateDate,
Course.CourseName from paper,Course
where paper.CourseID = Course.CourseID