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

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

• Used Book in Good Condition

<DIV><p>Get 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.</p><p>Discover how to:</p> <ul><li>Work with T-SQL and CLR user-defined functions, stored procedures, and triggers.</li> <li>Handle transactions, concurrency, and error handling.</li> <li>Efficiently use temporary objects, including temporary tables, table variables, and table expressions.</li> <li>Evaluate when to use set-based programming techniques and when to use cursors.</li> <li>Work with dynamic SQL in an efficient and secure manner.</li> <li>Treat date- and time-related data in a robust manner.</li> <li>Develop CLR user-defined types and learn about temporal support in the relational model.</li> <li>Use XML and XQuery and implement a dynamic schema solution.</li> <li>Work with spatial data using the new geometry and geography types and spatial indexes.</li> <li>Track access and changes to data using extended events, SQL Server Audit, change tracking, and change data capture.</li> <li>Use Service Broker for controlled asynchronous processing in database applications.</li> </ul><p>All the book€s code samples will be available for download from the companion Web site.</p></div>