SQL Server 2012 T-SQL Programming Unleashed

Overview

In SQL Server 2012 T-SQL Programming Unleashed, leading SQL Server consultant David Solomon shows database programmers how to take full advantage of it. This comprehensive how-to guide integrates exceptionally useful examples with detailed discussions of the underlying database behavior they illustrate. It provides self-contained modular coverage of each topic for rapid reference, and is organized intelligently to help readers build their knowledge incrementally as they proceed through the book. Solomon illuminates both the fundamental characteristics of T-SQL processing and the relationship between T-SQL code style and performance. Coverage includes:
• T-SQL basics: how T-SQL and SQL Server interact
• Data manipulation: database objects, DML, selection, complex queries, data modification, loading, and merge
• Batch programming: transactions, logging, locking, temporary storage, Dynamic SQL, server-side cursors, and error handling
• Creating SQL programming objects: views, stored procedures, UDFs, and triggers
• Using CLR to integrate non-SQL programs
• And much more

Read More