DATEFROMPARTS function in TSQL
SQL Server 2012 adds a new function called DateFromParts. This new function simplifies the creating of a DATE type in TSQL over the older ways of… Read More »DATEFROMPARTS function in TSQL
Whats New
T-SQL 2012 Procedure sp_describe_first_result_set
SQL Server 2012 adds a new stored procedure called sp_describe_first_result_set. This new procedure returns metadata for the result set returned from a query. The metadata is… Read More »T-SQL 2012 Procedure sp_describe_first_result_set
Exploring the TSQL Enhancements in SQL Server 2012 – Slides and Sample Code
I just finished the Exploring the TSQL Enhancements in SQL Server 2012 presentation at SQL Saturday 166 in Olympia Washington. Thanks everyone who attended, I hope… Read More »Exploring the TSQL Enhancements in SQL Server 2012 – Slides and Sample Code
SEQUENCE Sample Code from SQL Saturday in Olympia WA
The sample code below is a quick run down of the new sequence object introduced in SQL Server 2012. Just part of my Whats New… Read More »SEQUENCE Sample Code from SQL Saturday in Olympia WA
Sessions Accepted for Seattle Code Camp 2012
I learned today that several of the sessions that I pitched for Code Camp 2012 have been accepted. Code Camp will be on Saturday June… Read More »Sessions Accepted for Seattle Code Camp 2012