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

 

posted @ 2016-07-27 15:49  代码沉思者  阅读(381)  评论(0)  编辑  收藏  举报