–Parse String (amount with currency) to money
SELECT PARSE(‘€791,33’ AS money USING ‘de-DE’)

— Returns a value cast to the specified data type if the cast succeeds; otherwise, returns null.
SELECT  TRY_CONVERT(integer, ‘hello’) 
SELECT TRY_PARSE(‘Jabberwokkie’ AS datetime2 USING ‘en-US’) AS Result

— Return Orange, choose 2nd item from the list
SELECT CHOOSE ( 2, ‘Apple’, ‘Orange’, ‘Lemon’ ) AS Result;

— Return Biro, similar to excel function
SELECT IIF ( 7 > 9, ‘Amar’, ‘Biro’ ) AS Result;

— Return “Jack Monde 123”, Combine 2 or more object, accept string, null, number, etc
SELECT CONCAT ( ‘Jack  ‘, ‘Monde ‘, NULL, 123 )

— Date Formatting Function
DECLARE @d DATETIME = ’10/16/2005′;

SELECT FORMAT ( @d, ‘d’, ‘de-de’ ) AS ‘German’
SELECT FORMAT ( @d, ‘d’, ‘en-gb’ ) AS ‘Great Britain’
SELECT FORMAT ( @d, ‘d’, ‘zh-cn’ ) AS ‘Simplified Chinese’

— Return:
image

— New Dynamic Management Views & Functions

SELECT * FROM  sys.dm_os_volume_stats (1, 1)

SELECT * FROM  sys.dm_server_services

SELECT * FROM  sys.dm_server_registry