摘要:
SQLServerSELECT DATEADD(dd,ROW_NUMBER() OVER(ORDER BY a.number ASC),'2011.01.01')FROM MASTER.dbo.spt_values a CROSS JOIN MASTER.dbo.spt_values b WHERE a.TYPE = 'P' AND b.TYPE = 'P' AND a.number < 50 AND b.number < 50DB2select TIMESTAMP(TIMESTAMP('2005-01-01 0:00:00& 阅读全文
posted @ 2013-11-29 14:39 生命如风 阅读(110) 评论(0) 推荐(0) 编辑