{"product_id":"9781430245971","title":"Pro T-SQL 2012 Programmer's Guide","description":"\u003cp\u003e    \u003cem\u003ePro T–SQL 2012 Programmer’s Guide\u003c\/em\u003e is every developer’s key to making full use of SQL Server 2012’s powerful, built–in Transact–SQL language. Discussing new and existing features, the book takes you on an expert guided tour of Transact–SQL functionality. Fully functioning examples and downloadable source code bring technically accurate and engaging treatment of Transact–SQL into your own hands. Step–by–step explanations ensure clarity, and an advocacy of best–practices will steer you down the road to success.\u003c\/p\u003e\u003cp\u003e \u003c\/p\u003e\u003cp\u003e Transact–SQL is the language developers and DBAs use to interact with SQL Server. It’s used for everything from querying data, to writing stored procedures, to managing the database. New features in T-SQL 2012 include full support for window functions, stored sequences, the ability to throw errors, data paging, and more. All these important new features are covered in this book. Developers and DBAs alike can benefit from the expressive power of Transact-SQL, and \u003cem\u003ePro T-SQL 2012 Programmer's Guide\u003c\/em\u003e provides the gateway to success in applying this increasingly important database language to everyday business and technical tasks.      \u003c\/p\u003e    What you’ll learn\u003cul\u003e  \u003cli\u003eTake full advantage of window functions and other new features in T-SQL 2012 \u003c\/li\u003e  \u003cli\u003eMove business logic into the database via procedures and functions \u003c\/li\u003e  \u003cli\u003eDevelop using advanced features such as encryption and full-text search \u003c\/li\u003e  \u003cli\u003eStore and retrieve XML data using XQuery and XPath \u003c\/li\u003e  \u003cli\u003eDebug and Optimize T-SQL Execution \u003c\/li\u003e  \u003cli\u003eBuild ADO.NET Client Applications \u003c\/li\u003e \u003c\/ul\u003e Who this book is for      \u003cp\u003e     \u003cem\u003ePro T–SQL 2012 Programmer’s Guide\u003c\/em\u003e is written for SQL Server and Transact–SQL developers who want to implement best–practices and take full advantage of all that SQL Server has to offer. NET programmers will find the book helpful in showing how to run .NET code within SQL Server. Database administrators who need to write triggers and the occasional stored procedure will also benefit from the book.       \u003c\/p\u003e     Table of Contents\u003col\u003e  \u003cli\u003eFoundations of T-SQL \u003c\/li\u003e  \u003cli\u003eTools of the Trade \u003c\/li\u003e  \u003cli\u003eProcedural Code and CASE Expressions \u003c\/li\u003e  \u003cli\u003eUser Defined Functions \u003c\/li\u003e  \u003cli\u003eStored Procedures \u003c\/li\u003e  \u003cli\u003eTriggers \u003c\/li\u003e  \u003cli\u003eEncryption \u003c\/li\u003e  \u003cli\u003eCommon Table Expressions \u003c\/li\u003e  \u003cli\u003eAdvanced Features \u003c\/li\u003e  \u003cli\u003eIntegrated Full-Text Search \u003c\/li\u003e  \u003cli\u003eXML \u003c\/li\u003e  \u003cli\u003eXQuery and XPath \u003c\/li\u003e  \u003cli\u003eCatalog Views and Dynamic Management Views \u003c\/li\u003e  \u003cli\u003eSQL CLR Programming \u003c\/li\u003e  \u003cli\u003e.NET Client Programming \u003c\/li\u003e  \u003cli\u003eData Services \u003c\/li\u003e  \u003cli\u003eError Handling and Dynamic SQL \u003c\/li\u003e  \u003cli\u003ePerformance Monitoring and Tuning \u003c\/li\u003e  \u003cli\u003eAppendix A \u003c\/li\u003e  \u003cli\u003eAppendix B \u003c\/li\u003e  \u003cli\u003eAppendix C \u003c\/li\u003e  \u003cli\u003eAppendix D \u003c\/li\u003e \u003c\/ol\u003e","brand":"Apress","offers":[{"title":"Default Title","offer_id":47134050812144,"sku":"9781430245971","price":34.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0737\/7593\/9824\/files\/9781430245971_p0.jpg?v=1763750395","url":"https:\/\/shop-qa.barnesandnoble.com\/products\/9781430245971","provider":"Barnes \u0026 Noble (DEV)","version":"1.0","type":"link"}