Nov 21, 2014

[Tips] Create numbers 0 to 23 query

Query below creates numbers 0 to 23.

WITH Hours(h) AS
(
    SELECT 0
    UNION ALL
    SELECT h+1 FROM Hours WHERE h < 23
)
SELECT h FROM Hours

[Tips] Database convert to date

Oracle	`SELECT to_date('01-JAN-2014', 'dd.MM.yyyy') FROM dual`
SQL Server	`SELECT CAST('01-JAN-2014' AS DATE)`
SQL Server	`SELECT CONVERT(DATE,'01/JAN/2014')`

How to force IE mode to the latest version?

<meta http-equiv="X-UA-Compatible" content="IE=edge">