New Features in SQL Server 2012 for Database Developers


Feb 10, 2012

Introduction

At SQLPASS 2011, Microsoft has announced the launch of SQL Server 2012 which was also known to the SQL Server Community by its code name SQL Server Denali. It is expected that Microsoft will release SQL Server 2012 in the first half of year 2012. Currently SQL Server Enthusiast can download the Microsoft SQL Server 2012 Release Candidate 0 (RC0) version of SQL Server 2012 to explore new feature in the product.

Quick Overview of New Features in Microsoft SQL Server 2012 for Database Developers

Microsoft SQL Server 2012 introduces lot many new features for Business Intelligence Developers, TSQL Developers and Database Administrators. This article gives you an overview of some of the new features in SQL Server 2012 for Database Developers.

SQL Server Paging Using OFFSET and FETCH Feature in SQL Server 2012

Microsoft SQL Server 2012 introduces an interesting clause namely OFFSET and FETCH to the existing ORDER BY clause. Using OFFSET and FETCH clause developers can write TSQL code to fetch only a set of rows from the complete result set window. This will help developers going forward achieve SQL Server Pagination there by improving performance when retrieving and displaying large number of records from backed database. For more information read SQL Server Paging Using OFFSET and FETCH Feature in SQL Server 2012.

WITH RESULT SETS Feature in SQL Server 2012

Microsoft SQL Server 2012 extends the EXECUTE statement to introduce WITH RESULT SETS option which can be used to change the column name and data types of the result set returned by the stored procedure execution. For more information read Using WITH RESULT SETS Feature in SQL Server 2012.



Sequence Numbers in SQL Server 2012

Microsoft SQL Server 2012 introduces an interesting feature namely Sequence Objects for database developer. MSDN describes Sequence Number as “a sequence object is a user-defined schema-bound object that generates a sequence of numeric values according to the specification with which the sequence was created. It operates similar to an identity column, but sequence numbers are not restricted to use in a single table.”

THROW statement in SQL Server 2012

In SQL Server 2012 Microsoft has introduced THROW Statement which will help developers to handle error easily. A developer will be able to use THROW statement to raise an exception and then to transfer the execution to a CATCH block of the TRY...CATCH. For more information read Error Handling Using Throw Statement in SQL Server 2012.

Conclusion

In this article you have seen some of the new features which are introduced in Microsoft SQL Server 2012 for Database Developers.


Continue Free Learning...

  • Please leave below your valuable feedback for this article.
  • Feel Free to refer this article to your friends and colleagues using the below “Share this Article” option.
  • Do subscriber to our News Letter to continue your free learning.
  • Don’t forget to Like Us on Facebook and do follow us on Twitter for latest updates.

Share this Article


History of Microsoft SQL Server


Geeks who read this article also read…




Follow @MyTechMantra on Twitter
We're on Facebook
Bookmark and Share

"Receive newsletters and special offers about SQL Server, BizTalk and SharePoint from MyTechMantra. We respect your privacy and you can unsubscribe at any time."