晨风

-------------------- 业精于勤,荒于嬉;行成于思,毁于随

导航

05 2016 档案

摘要:SELECT CONVERT(VARCHAR(7),DATEADD(MONTH,number,'2016-01-01'),120) FROM master..spt_values WHERE type='P' AND DATEADD(MONTH,number,'2016-01-01')<='2017 阅读全文

posted @ 2016-05-27 16:31 shenyixin 阅读(2375) 评论(0) 推荐(0) 编辑

摘要:select convert(varchar(10),dateadd(dd,number,convert(varchar(8),getdate(),120)+'01'),120) as dt from master..spt_values where type='P' and dateadd(dd,number,convert(varchar(8),getdate(),120)+'01')<... 阅读全文

posted @ 2016-05-20 09:59 shenyixin 阅读(1985) 评论(0) 推荐(1) 编辑