This is a coder's book. It's intended to help developers build applications that make use of Transact-SQL. It's not about database administration or design. The companion website also provides all of the code examples from the book. This unique cookbook contains a wealth of solutions to problems that SQL programmers face all the time. The recipes inside range from how to perform simple tasks, like importing external data, to ways of handling issues that are more complicated, like set algebra.
Authors Ales Spetic and Jonathan Gennick, two authorities with extensive database and SQL programming experience, include a discussion with each recipe to explain the logic and concepts underlying the solution. The Transact-SQL Cookbook is designed so you can use the recipes directly, as a source of ideas, or as a way to learn a little more about SQL and what you can do with it. Topics covered include: Audit logging. In addition to recipes for implementing an audit log, this chapter also includes recipes for: improving performance where large log tables are involved; supporting multiple-languages; and simulating server push.
Recipes show you how to manipulate hierarchical data using Transact-SQL. Importing data. This chapter introduces concepts like normalization and recipes useful for working with imported data tables.
Recipes demonstrate different operations, such as how to find common elements, summarize the data in a set, and find the element in a set that represents an extreme.
This chapter? Temporal data. Recipes demonstrate how to construct queries against time-based data. Data Structures. This chapter shows how to manipulate data structures like stacks, queues, matrices, and arrays. With an abundance of recipes to help you get your job done more efficiently, the Transact-SQL Cookbook is sure to become an essential part of your library.
New features in T-SQL include full support for window functions, stored sequences, the ability to throw errors, data paging, and more.
Expert tips and real code examples teach advanced database programmers to write more efficient and better-performing code that takes full advantage of T-SQL. The authors offer practical solutions to the everyday problems programmers face and include in-depth information on advanced T-SQL topics such as joins, subqueries, stored procedures, triggers, user-defined functions UDFs , indexed views, cascading actions, federated views, hierarchical structures, cursors, and more.
Some familiarity with relational databases and basic SQL is expected, and some programming experience is helpful. The primary audience is database developers; secondary markets include database administrators DBAs and business analysts. After a quick review of basic query language commands and syntax, the author quickly moves to show how to design and build applications of increasing complexity.
NET, Sams offers the most comprehensive coverage of object-oriented development, distributed application development, and Web Services. Therefore, has broad, general appeal to novices who are browsing shelves, and looking for a book that makes sense of SQL Server entirely. You may already have a basic idea of what SQL is used for, but you may not have a good understanding of the concepts behind relational databases and the purpose of SQL.
This book will help you build a solid foundation of understanding, beginning with core relational database concepts and continuing to reinforce those concepts with real-world T-SQL query applications. If you are familiar with relational database concepts but are new to Microsoft SQL Server or the T-SQL language, this book will teach you the basics from the ground up.
T-SQL insiders help you tackle your toughest queries and query-tuning problems Squeeze maximum performance and efficiency from every T-SQL query you write or tune. Emphasizing a correct understanding of the language and its foundations, the authors present unique solutions they have spent years developing and refining.
The language provides programmers with a broad range of features, including: A rich set of datatypes, including specialized types for identifiers, timestamps, images, and long text fieldsLocal and global variablesFully programmable server objects like views, triggers, stored procedures, and batch command filesConditional processingException and error handlingFull transaction controlSystem stored procedures that reduce the complexity of many operations, like adding users or automatically generating HTML Web pagesIn recent years, the versions of Transact-SQL have diverged on Microsoft and Sybase systems; the book explains the differences.
It also contains up-to-the-minute information on the latest versions: Microsoft SQL Server versions 6. Introduction to Transact-SQL2. Matching Business Rules3. SQL Primer4. Transact-SQL Fundamentals5. Datatypes and Variables7. Conditional Processing8. Row Processing with Cursors9. Error Handling Temporary Objects Stored Procedures and Modular Design System TablesB.
Provides detailed information about Transact-SQL programming and shows specific differences between the Microsoft and Sybase versions of the language. If you've not programmed with Transact-SQL, this book is for you. The book then moves to show you how to design and build applications of increasing complexity.
0コメント