摘要:
How to convert from string to datetime in sql server? - Sealyu - BlogJava Execute the following T-SQL scripts in Microsoft SQL Server Manangement Studio Query Editor to demonstrate T-SQL convert and ... 阅读全文
摘要:
某测试人员提出一个Bug,说要排序,按A,B排序, 按B排序的时候,当B为空时需要再按A排序。 好开写: SELECT * FROM TABLE1 ORDER BY B DESC SELECT * FROM TABLE1 ORDER BY ISNULL(B,A) DESC SELECT * FROM TABLE1 ORDER BY B DESC,A DESC 哈哈,第二第三个应该都对。但是应... 阅读全文
摘要:
SELECT * FROM (SELECT B.NAME FROM SYSOBJECTS ALEFT JOIN SYSCOLUMNS BON A.ID = B.IDWHERE A.NAME = '表名1') SS WHERE NAME NOT IN(SELECT B.NAME FROM SYSOBJECTS ALEFT JOIN SYSCOLUMNS BON A.ID = B.IDWHERE A.... 阅读全文
摘要:
Windows Server 2008 R2 Editions 180day Evaluation Key:Windows Web Server 2008 R2 = KBV3Q-DJ8W7-VPB64-V88KG-82C49 Windows Server 2008 R2 Standard = 4GGC4-9947F-FWFP3-78P6F-J9HDR (可用 2010-08-08)Windows ... 阅读全文
摘要:
代码 Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/--1SETANSI_NULLSON2GO3SETQUOTED_IDENTIFIERON4GO56CREATEFUNCTION[dbo].[fn_GetSubCasNoTree](@CAS_NOVARC... 阅读全文