摘要:系列:http://www.cnblogs.com/DBFocus/archive/2011/03/27/1996655.html技巧:http://www.cnblogs.com/Terrylee/archive/2005/10/10/251790.html论坛:http://www.sqlservercentral.com/
阅读全文
posted @ 2013-10-18 10:14
|
|||
随笔分类 - SQLServer
摘要:系列:http://www.cnblogs.com/DBFocus/archive/2011/03/27/1996655.html技巧:http://www.cnblogs.com/Terrylee/archive/2005/10/10/251790.html论坛:http://www.sqlservercentral.com/
阅读全文
posted @ 2013-10-18 10:14
摘要:datetime2(3)精确到毫秒(听说),约等于2005时代的datetime类型。实际上后者是精确到3.33毫秒(也是听说)。DECLARE @D0 datetime2(0) = GETDATE();DECLARE @D1 datetime2(1) = GETDATE();DECLARE @D2 datetime2(2) = GETDATE();DECLARE @D3 datetime2(3) = GETDATE();DECLARE @D4 datetime2(4) = GETDATE();DECLARE @D5 datetime2(5) = GETDATE();DECLARE @D6 d
阅读全文
posted @ 2013-10-17 17:21
|
|||