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 2008 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.
In addition to the powerful features available in T-SQL for developing SQL code and stored procedures, triggers, and user-defined functions, SQL Server 2008 also enables you to define custom-managed database objects such as stored procedures, ...
Get Microsoft® SQL Server 2008 R2 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.
