Inside Microsoft® SQL Server® 2008: T-SQL Programming (Pro-Developer)

DIVpGet a detailed look at the internal architecture of T-SQL with this comprehensive programming reference. Database developers and administrators get best practices, expert techniques, and code samples to master the intricacies of this programming language—solving complex problems with real-world solutions./ppDiscover how to:/p ulliWork with T-SQL and CLR user-defined functions, stored procedures, and triggers./li liHandle transactions, concurrency, and error handling./li liEfficiently use temporary objects, including temporary tables, table variables, and table expressions./li liEvaluate when to use set-based programming techniques and when to use cursors./li liWork with dynamic SQL in an efficient and secure manner./li liTreat date- and time-related data in a robust manner./li liDevelop CLR user-defined types and learn about temporal support in the relational model./li liUse XML and XQuery and implement a dynamic schema solution./li liWork with spatial data using the new geometry and geography types and spatial indexes./li liTrack access and changes to data using extended events, SQL Server Audit, change tracking, and change data capture./li liUse Service Broker for controlled asynchronous processing in database applications./li /ulpAll the book’s code samples will be available for download from the companion Web site./p/div