作者:Michael Coles
出版日期:August 11, 2008
出版社:Apress
页数:688
ISBN:ISBN-10: 143021001X ISBN-13: 978-1430210016
文件格式:PDF
Product Description
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 yourown hands. Step–by–step explanations ensure clarity, and an advocacy ofbest–practices will steer you down the road to success.Pro T–SQL 2008 Programmer’s Guide is every developer’s keyto making full use of SQL Server 2008’s powerful, built–in Transact–SQLlanguage. Transact–SQL is the language developers and DBAs use tointeract with SQL Server. It’s used for everything from querying data,to writing stored procedures, to managing the database. New features inSQL Server 2008 include a spatial data type, SQLCLR integration, theMERGE statement, a dramatically improved and market–leading XML featureset, and support for encryption—all of which are covered in this book
What you’ll learnWrite stored procedures, functions, and triggers using Transact–SQLApply best–practices when centralizing procedural logic inside your SQL Server database.Seamlessly work with XML data using XQuery, XPath, and the XML type.Use SQLCLR to write .NET code that runs inside SQL Server.Implement full–text search within your database.Load data more efficiently using the new MERGE statement.Learn about the new geography type for storing spatial data.Who is this book for?Pro T–SQL 2008 Programmer’s Guide is written for SQL Serverand Transact–SQL developers who want to implement best–practices andtake full advantage of all that SQL Server has to offer. .NETprogrammers will find the book helpful in showing how to run .NET codewithin SQL Server. Database administrators who need to write triggersand the occasional stored procedure will also benefit from the book.
About the Apress Pro SeriesThe Apress Pro series books are practical, professional tutorials to keep you on and moving up the professional ladder.
You have gotten the job, now you need to hone your skills in thesetough competitive times. The Apress Pro series expands your skills andexpertise in exactly the areas you need. Master the content of a Probook, and you will always be able to get the job done in a professionaldevelopment project. Written by experts in their field, Pro seriesbooks from Apress give you the hard–won solutions to problems you willface in your professional programming career.
About the Author
Michael Coles has over a decade’s experience designing andadministering SQL Server databases. A prolific writer of articles onall aspects of SQL Server, particularly on the expert use of T–SQL, heholds MCDBA and MCP certifications. He received a bachelor’s of science(magna cum laude) in information technology from AmericanIntercontinental University. A member of the United States ArmyReserve, he was activated for two years following 9/11.