Synopses & Reviews
Discussing new and existing features, SQL Server designer and administrator Michael Coles takes you on an expert guided tour of Transact?SQL functionality in SQL Server 2008 in his book, Pro T?SQL 2008 Programmer's Guide. Fully functioning examples and downloadable source code bring Coles? 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.
Pro T?SQL 2008 Programmer's Guide is every developer's key to making full use of SQL Server 2008's powerful, built?in Transact?SQL language. 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 SQL Server 2008 include a spatial data type, SQLCLR integration, the MERGE statement, a dramatically improved and market?leading XML feature set, and support for encryption?all of which are covered in this book What you?ll learn Write stored procedures, functions, and triggers using Transact?SQL Apply best?practices when centralizing procedural logic inside your SQL Server databaseSeamlessly work with XML data using XQuery, XPath, and the XML typeUse SQLCLR to write .NET code that runs inside SQL ServerImplement full?text search within your databaseLoad data more efficiently using the MERGE statementLearn about the new geography type for storing spatial data Who this book is for
Pro T?SQL 2008 Programmer's Guide 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.
Skill with the Transact-SQL language is key to any developer making use of Microsoft SQL Server. Written especially for developers, the Pro T-SQL 2008 Programmera (TM)s Guide shows developers the full range of whata (TM)s possible using the language. Readers become fully-grounded in the language, in the key features that SQL Server has to offer, and they are introduced to best-practices that will help ensure their success.