摘要: select dateadd(dd,number,'2012-1-1') AS date from master..spt_values where type='p' and dateadd(dd,number,'2012-1-1')<='2012-12-30' 阅读全文
posted @ 2017-07-14 11:03 huangzebin 阅读(545) 评论(0) 推荐(0) 编辑
摘要: decimal test=1.2000;test.ToString("0.####"); 阅读全文
posted @ 2017-07-14 09:08 huangzebin 阅读(1071) 评论(0) 推荐(1) 编辑