Summary
Transact-SQL has always been a powerful data access and data modification language, providing additional features, such as functions, variables, and commands, to control execution flow. SQL Server 2012 further expands the power and capabilities of T-SQL with the addition of a number of new features. These new T-SQL features can be incorporated into the building blocks for creating even more powerful SQL Server database components, such as views, stored procedures, triggers, and user-defined functions.
With the features available in T-SQL, it is important to be sure you are using them effectively and efficiently. The next chapter provides a number of tips, tricks, and guidelines to help you get the most out of SQL Server using Transact-SQL. ...
Get Microsoft® SQL Server 2012 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.
