All 14 new SQL Server 2012 Functions in one quick guide, from TRY_CONVERT and PARSE to DATEFROMPARTS and CHOOSE, each linked to my post and Books Online.
SQL SERVER – Denali – Date and Time Functions – EOMONTH() – A Quick Introduction
A quick introduction to the EOMONTH function in SQL Server Denali: get the last day of the month for a date, one of seven new date and time functions.
SQL SERVER 2012 – DateTime Functions – DATEFROMPARTS() – DATETIMEFROMPARTS() – DATETIME2FROMPARTS()
SQL Server 2012 adds seven new datetime functions, such as DATEFROMPARTS, DATETIMEFROMPARTS and EOMONTH. A quick look at building dates from their parts.
Moving Averages in T-SQL
Moving averages in T-SQL use ROWS BETWEEN for rolling windows, but date gaps and duplicate dates decide what the result actually means.
SQL SERVER – Denali – String Function – FORMAT() – A Quick Introduction
A quick introduction to the FORMAT function in SQL Server Denali: locale-aware formatting of dates and numbers, built on the .NET Framework and CLR.
SQL SERVER 2012 – String Function CONCAT() – A Quick Introduction
SQL Server 2012 adds the String Function CONCAT(), which joins two or more values into one string. Examples show how it handles numbers, dates and NULLs.
SQL SERVER – Denali – New Functions and Shorthand for CASE Statement
Do the new Denali functions replace the CASE statement? No. They are shorthand for CASE statement logic, and TRY_PARSE works well with CASE.