Microsoft has announced the next version of SQL Server will be SQL Server 2014, and that a pre-release version will be available later this year. Some of the features announced SQL Server 2014 are: new disaster recovery and backup solutions with Windows Azure enhanced self service BI tools high availability improvements, to the Always On capabilities in memory OLTP for …
For more information on cursors, also take a look at the free SQL query training provided by Steve Stedman. Cursors are a feature of SQL Server that allow users to iterate through a result set one row at a time. This can be useful in situations where a user needs to perform a set of operations on each row of a …
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 …