随笔分类 -  SQL Server

SQL Server
摘要:在一个项目中用到的数据库是sqlserver 2008 r2 express 。可没想到express版本的功能有些限制,此前一直都不知道啊。百度百科可以看到它的限制: “1.数据库的大小限制:SQL Server 2005 Express 和SQL Server 2008 Express 数据库的 阅读全文
posted @ 2018-01-13 10:22 blackhole1 阅读(982) 评论(0) 推荐(0)
摘要:select * from (SELECT DISTINCT ClassID,rgbvalue FROM (SELECT ClassID,Monday,Tuesday,Wednesday FROM EDU_CourseTable where ClassID =145) p UNPIVOT (rgbv 阅读全文
posted @ 2016-11-08 16:26 blackhole1 阅读(214) 评论(0) 推荐(0)
摘要:with tt as( select ID,INFOTITLE,INFOCONTENT,CreateTime,CreateCode,IsRead ,data FROM (SELECT ID,INFOTITLE,INFOCONTENT,CreateTime,CreateCode,IsRead ,(se 阅读全文
posted @ 2016-08-12 09:40 blackhole1 阅读(537) 评论(0) 推荐(0)
摘要:with tt as(select s.MorOrAftOrEve, case s.MorOrAftOrEve when 1 then '上午' when 2 then '下午' else '晚上' end as MAE ,'第'+cast(s.Section as varchar(10))+'节' 阅读全文
posted @ 2016-08-12 09:38 blackhole1 阅读(191) 评论(0) 推荐(0)