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 doing it. The information here has been extracted from my SQL Saturday presentation on Whats New in TSQL 2012. Pre-SQL 2012 First lets take a look at how you would do the equivalent to DateFromParts before SQL …
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 information about what the results will look like. sp_describe_first_result_set is an alternative to sp_columns, and appears to perform much better than sp_columns. The information here has been extracted from my SQL Saturday presentation on Whats New in TSQL …
T-SQL 2012 Procedure sp_describe_first_result_set Read more »
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 that you learned something useful. Here is the slides and sample code to download: Whats New in TSQL 2012 If you have any questions, please get in touch with me on Twitter @SqlEmt Remember to follow me …
Exploring the TSQL Enhancements in SQL Server 2012 – Slides and Sample Code Read more »
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 in TSQL 2012 presentation at SQL Saturday 166.
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 16th 2012 in Redmond WA. I am not sure why the call it Seattle Code Camp if it is going to be in Redmond. Looking forward to it. Today I am tuning up …