摘要：
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 阅读(2384) 评论(0) 推荐(0)
|
||
|
摘要：
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 阅读(2384) 评论(0) 推荐(0) |
||
浙公网安备 33010602011771号