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.
Surrogate Keys and Natural Keys
Surrogate keys keep warehouse history stable while natural keys preserve source identity; learn lookup, uniqueness, and change handling.
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.
SQLAuthority News – Uncut and Unedited – Interview of Pinal Dave on Book Authoring
I was very happy when books were published and I got a print copy in my hand. In this blog post we will discuss about Book Authoring.