Sql Server 2012 adds lots of new
features in the form of IDE, coding and programming Enhancements.
· The most and bigger change to SSMS (management
studio) is that it's built on Visual Studio 2010. So, now Sql server 2012 now
supports multi-monitor support.
· Another productivity benefit of
SQL server 2012 is supports code snippets same like Visual studio within
management studio. You can accessed via hotkeys (Ctrl+K, X and Ctrl+K).
· Now SQL Server 2012 supports most
awaited functionality is THROW statement and in-built Pagination
(using OFFSET and FETCH with order by clause).
· Choose () function: returns the item at the specified index from a list of
values (like array).
· Developer who are familiar with
.Net framework now can also use Sql server new function like TRY_CONVERT
(), TRY_PARSE () and Format (for format date) functions.
· SQL servers express Local DB: lightweight
version of SQL Server that has many programmability features of a SQL
Server database like stored procedures, user-defined functions and
aggregates, .NET Framework integration,spatial types and others that are
not available in SQL Server Compact. It does not support FILESTREAM and only allows local
queues for Service Broker.
In nutshell, SQL server 2k12 does a great job of by introducing CLR functionality directly into T-SQL, which makes T-SQL programming very easy.
No comments:
Post a Comment