{"product_id":"9780735626027","title":"Inside Microsoft SQL Server 2008 T-SQL Programming","description":"\u003cp\u003eGet 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.\u003c\/p\u003e\u003cp\u003eDiscover how to:\u003c\/p\u003e\u003cp\u003e \u003c\/p\u003e\u003cul\u003e \u003cli\u003eWork with T-SQL and CLR user-defined functions, stored procedures, and triggers.\u003c\/li\u003e \u003cli\u003eHandle transactions, concurrency, and error handling.\u003c\/li\u003e \u003cli\u003eEfficiently use temporary objects, including temporary tables, table variables, and table expressions.\u003c\/li\u003e \u003cli\u003eEvaluate when to use set-based programming techniques and when to use cursors.\u003c\/li\u003e \u003cli\u003eWork with dynamic SQL in an efficient and secure manner.\u003c\/li\u003e \u003cli\u003eTreat date- and time-related data in a robust manner.\u003c\/li\u003e \u003cli\u003eDevelop CLR user-defined types and learn about temporal support in the relational model.\u003c\/li\u003e \u003cli\u003eUse XML and XQuery and implement a dynamic schema solution.\u003c\/li\u003e \u003cli\u003eWork with spatial data using the new geometry and geography types and spatial indexes.\u003c\/li\u003e \u003cli\u003eTrack access and changes to data using extended events, SQL Server Audit, change tracking, and change data capture.\u003c\/li\u003e \u003cli\u003eUse Service Broker for controlled asynchronous processing in database applications.\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003eAll the book’s code samples will be available for download from the companion Web site.\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e","brand":"Microsoft Press","offers":[{"title":"Default Title","offer_id":47014677512432,"sku":"9780735626027","price":59.99,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0737\/7593\/9824\/files\/9780735626027_p0.jpg?v=1763628883","url":"https:\/\/shop-qa.barnesandnoble.com\/products\/9780735626027","provider":"Barnes \u0026 Noble (DEV)","version":"1.0","type":"link"}