视图的建立.sql

来自「初学者」· SQL 代码 · 共 15 行

alter VIEW STU_INFO(学生名,成绩,年龄,电话,电子邮件,班级,学院)
AS
SELECT  STU_NAME,ISNULL(CAST(STU_SCORE AS CHAR(10)),'成绩未录入'),
        ISNULL(CAST(DATEDIFF(YY,STU_BIRTHDAY, GETDATE()) AS CHAR(20)),'暂无') AS STU_AGE,
        ISNULL(STU_TEL,'暂无'),
        ISNULL(STU_EMAIL,'暂无')AS EMAIL,CLASS_NAME, 
       [COL_NAME]
FROM  STU_PAPER LEFT OUTER JOIN
       PAPER ON dbo.STU_PAPER.PAPER_ID =  PAPER.PAPER_ID LEFT OUTER JOIN
       STUDENT ON dbo.STU_PAPER.STU_ID =  STUDENT.STU_ID LEFT OUTER JOIN
       CLASS LEFT OUTER JOIN  CLASS_STU ON 
       CLASS.CLASS_ID =  CLASS_STU.CLASS_ID LEFT OUTER JOIN  COLLEGE ON 
       CLASS.COL_ID =  COLLEGE.COL_ID ON 
       STUDENT.STU_ID =  CLASS_STU.STU_ID