摘要：
SELECT *FROM ScoreInfogoName Course Score---------- ---------- -----------Lucy Chinese 74Jim Math 83Angkor English 93Tom Chinese 74Leon Math 84Evan English 94(6 row(s) affected)SELECT Name , MAX(CASE Course WHEN 'Ch... 阅读全文
摘要：
SQL SQL Server 2012 新增加的几个函数：SELECT CONVERT (INT, 'Angkor-216.00') 直接报错SELECT TRY_CONVERT(INT, 'SSD-216.00') 输出：NULLSELECT TRY_CONVERT(INT, '216') 输出：416SELECT TRY_CONVERT(DATETIME, '216') 输出：NULLDECLARE @birthdate datetime = '2013-11-05'Select FORMAT (@birthd 阅读全文