Microsoft® SQL Server 2012 Unleashed

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. ...