10 2015 档案

Inaccurate values for “Currently allocated space” and “Available free space” in the Shrink File dialog for TEMPDB only
摘要：转载自：http://blogs.msdn.com/b/ialonso/archive/2012/10/08/inaccurate-values-for-currently-allocated-space-and-available-free-space-in-the-shrink-file-dialog-for-tempdb-only.aspx Inaccurate values for... 阅读全文
posted @ 2015-10-13 11:27 which 阅读(490) 评论(0) 推荐(0)
SQL Server 格式化时间format
摘要：select format(sysdatetime(),'yyyy-MM-dd HH:mm:ss');SQL Server 2012才开始有这功能这种样式很像oracle的to_char(sysdate,'yyyy-mm-dd hh24:mi:ss')注意yyyy-MM-dd这里MM是大写的，HH:... 阅读全文
posted @ 2015-10-10 15:19 which 阅读(324) 评论(0) 推荐(0)