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
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
转载于:https://www.cnblogs.com/yechangzhong-826217795/p/5711460.html