New Transact-SQL Enhancements
What would a new SQL Server release be without a number of new T-SQL commands and constructs to further expand the power and capabilities of the T-SQL language? However, SQL Server 2014 seems to be the exception.
Besides the T-SQL constructs and syntax elements introduced to support In-Memory OLTP, the only other new T-SQL constructs provided in SQL Server 2014 include the following:
Inline specification of CLUSTERED and NONCLUSTERED indexes in the CREATE TABLE command for disk-based tables. This feature is equivalent to issuing a create table followed by corresponding CREATE INDEX statements (this feature is covered ...
Get Microsoft SQL Server 2014 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
