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 …
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 …
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 …