22,209
社区成员
发帖
与我相关
我的任务
分享
create view TT AS
(
SELECT
B.[班号] AS 班级编号,
A.[班级名称],
A.[学籍号],
A.[民族代码],
A.[姓名],
A.[性别],
A.[出生日期],
A.[测试老师]
FROM
student_SC AS A
LEFT JOIN student_teacher AS B ON A.学籍号 = B.学号
)
CREATE VIEW TT
WITH SCHEMABINDING
AS
SELECT B.[班号] AS 班级编号 ,
A.[班级名称] ,
A.[学籍号] ,
A.[民族代码] ,
A.[姓名] ,
A.[性别] ,
A.[出生日期] ,
A.[测试老师]
FROM dbo.student_SC AS A
INNER JOIN dbo.student_teacher AS B ON A.学籍号 = B.学号;
GO
CREATE UNIQUE CLUSTERED INDEX IDX_TT ON TT([学籍号]);