haidongqingqq的专栏

This essential reference is designed for database developers and administrators who need to write queries and develop code using Transact-SQL (T-SQL), the Microsoft implementation of the standard SQL language. Guided by SQL Server guru Itzik Ben-Gan, you'll walk through the steps for writing queries, including retrieving and modifying data, with an overview of programmable objects supported by SQL Server 2008. Rather than focusing just on the syntactical elements of T-SQL, however, this book explains the logic behind the language - helping you develop a true, core understanding of the elements and how to use them. You will learn to think in terms of sets, and follow real-world best practices for T-SQL programming. To complement the learning experience, the book provides exercises to practice and apply what you've learned. And you'll examine recommended solutions to compare with your own work. The entire book's code samples will be available for download from the companion Web site.

Delve into the internal architecture of T-SQL—and unveil the power of set-based querying—with comprehensive reference and advice from a highly regarded T-SQL expert and members of Microsoft's SQL Server development team. Database developers and administrators will examine the best practices, advanced techniques, sample databases, and code needed to master the programming language built into SQL Server—solving complex problems with real-world solutions. ? Understand logical and physical query processing ? Learn about set theory, predicate logic, and the relational model ? Apply a methodology to optimize query tuning ? Analyze the algorithmic complexity of your queries ? Solve relational division problems ? Use CTEs and ranking functions to simplify and optimize solutions ? Aggregate data with various techniques, including tiebreakers, pivoting, histograms, grouping factors, and grouping sets ? Use the TOP option to query and modify data ? Use the MERGE statement to modify data based on conditional logic ? Maintain and query graph structures with the HIERARCHYID datatype, recursive queries, and other solutions ? PLUS—Improve your logic and get to the heart of querying problems with logic puzzles All the book’s code samples will be available for download from the companion Web site.

创建型：单件模式，抽象模式，建造者模式，工厂模式，原型模式； 结构型：适配器模式，桥接模式，装饰模式，组合模式，外观模式，享元模式，代理模式，命令模式，迭代器模式； 行为型：观察者模式，解释型模式，中介型模式，职责链模式，备忘录模式，策略模式，访问者模式，状态模式！