SQL Server 2012 T-SQL Programming Unleashed

Part I. Overview of SQL Server and Transact-SQL 1. Understanding Transact-SQL and SQL Server 2. Connecting to SQL Server with Management Studio Part II. Manipulating Data with T-SQL Commands 3. Understanding SQL Databases and Database Objects 4. Using Data Manipulation Language (DML) 5. Selecting Data In Depth 6. Writing Complex Queries 7. Modifying Data with Insert, Update, Delete 8. Loading Data with Bulk Insert 9. Using Merge to Build Complex Updates Part III. Programming with T-SQL Batches 10. Programming with T-SQL Batches 11. Understanding Transactions, Logging, and Locking 12. Handling Complex Cases with Temporary Storage 13. How to Use Dynamic SQL, and When Not 14. Using Server-Side Cursors in T-SQL 15. Handling Errors in Transact-SQL Part IV. Creating SQL Programming Objects 16. Creating and Managing Views 17. Creating and Managing Stored Procedures 18. Building Application-Ready Stored Procedures 19. Using CLR to Integrate Non-SQL Programs 20. Using User-Defined Functions 21. Creating and Managing Triggers