SQL系统视图表

SQL系统视图表

SELECT     sc.SCId AS listid, CAST(sc.SchoolYear AS nvarchar(4)) + '学年' + ss.Name AS listtext, sc.SchoolId
FROM         dbo.SchoolCalendar AS sc INNER JOIN
                      dbo.Semesters AS ss ON sc.SemesterId = ss.Id