New Features in SQL Server 2012 for Database Developers
Feb 10, 2012
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.
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...
History of Microsoft SQL Server
Geeks who read this article also read…
- New Features in Microsoft SQL Server 2012 for Database Administrators
- Using WITH RESULT SETS Feature of SQL Server 2012
- SQL Server Paging Using OFFSET and FETCH Feature in SQL Server 2012
- Indirect Checkpoint Feature in SQL Server 2012
- When SQL Server was last restarted?
- Change SA Password in SQL Server
- Troubleshooting SYSPOLICY_PURGE_HISTORY Job Failure in Stand Alone Instance SQL Server 2008
- Troubleshooting OLE DB Provider Microsoft.ACE.OLEDB.12.0 is not registered Error
- Troubleshooting SQL Server blocked access to procedure sp_send_dbmail
- Performance Dashboard Reports in SQL Server 2012
- Tips to Avoid Account Lockout Issues
- Encrypt Database Backups in SQL Server Using MEDIAPASSWORD Option
- Using SP_SERVER_DIAGNOSTICS Stored Procedure Quickly Gather Diagnostic Data and Health Information in SQL Server 2012
- How to Downgrade SQL Server Database from a higher version to a lower version
- Why an SQL Server Database from a higher version cannot be restored onto a lower version?
- How to identify if the database was upgraded from a previous version of SQL Server
- Microsoft SQL Server 2008 R2 Build Versions
- Installing SQL Server 2008 R2 on Windows Server 2008 R2
- New Features in Microsoft SQL Server 2008 R2
- How to repair a Suspect Database in SQL Server
- Steps to Rebuild System Databases in SQL Server
- How to Remotely Shutdown, Restart or Log Off Windows Server across the network
- How to Backup an Analysis Services Database Using SQL Server Management Studio
- Using Transparent Data Encryption Feature of SQL Server 2008
- Database Backup Compression Feature In SQL Server 2008
- Auditing SQL Server Logins
- Read More SQL Server Articles…