The Gurus Guide to SQL Server Stored Procedures, XML, and HTML [Electronic resources]

Ken Henderson

نسخه متنی -صفحه : 223/ 2

Guru's Guide to SQL Server™ Stored Procedures, XML, and HTML, The

By Ken Henderson

Publisher : Addison Wesley

Pub Date : December 28, 2001

ISBN : 0-201-70046-8

Pages : 800

Slots : 1

About the Sample Databases

Acknowledgments

About the Author

Part I: The Basics

Chapter 1. Stored Procedure Primer

What Is a Stored Procedure?

Stored Procedure Advantages

Creating a Stored Procedure

Altering Stored Procedures

Executing Stored Procedures

Extended Stored Procedures

Environmental Issues

Flow Control Language

Chapter 2. Suggested Conventions

Source Formatting

Coding Conventions

Chapter 3. Common Design Patterns

The Law of Parsimony

Design Patterns

Chapter 4. Source Code Management

The Benefits of Source Code Management

The dt Procedures

Version Control from Query Analyzer

Automating Script Generation with Version Control

Chapter 5. Database Design

General Approach

The Sample Project

The Five Processes

The Five Phases Examined

Modeling Business Processes

Entity-Relationship Modeling

Relational Data Modeling

Chapter 6. Data Volumes

Approaches to Generating Data

Part II: Objects

Chapter 7. Error Handling

Error Reporting

Handling Errors

Chapter 8. Triggers

Determining What Has Changed

Managing Sequential Values

Trigger Restrictions

INSTEAD OF Triggers

Triggers and Auditing

Calling Stored Procedures

Nested Triggers

Disabling Triggers

Chapter 9. Views

ANSI SQL Schema Views

Updatable Views

The WITH CHECK OPTION Clause

Parameterized Views

Partitioned Views

Designing Modular Indexed Views

Chapter 10. User-Defined Functions

Scalar Functions

Table-Valued Functions

Inline Functions

Creating Your Own System Functions

Part III: HTML, XML, and NET

Chapter 11. HTML

Producing HTML from Transact-SQL

Producing HTML from sp_makewebtask

Chapter 12. Introduction to XML

XML: An Overview

HTML: Simplicity Comes at a Price

XML: A Brief History

XML versus HTML: An Example

Document Type Definitions

Extensible Stylesheet Language Transformation (XSLT)

Document Object Model

Further Reading

Chapter 13. XML and SQL Server: HTTP Queries

Accessing SQL Server over HTTP

Template Queries

Chapter 14. XML and SQL Server: Retrieving Data

SELECT…FOR XML

Mapping Schemas

Chapter 15. XML and SQL Server: OPENXML

The Flags Parameter

Edge Table Format

Inserting Data with OPENXML()

Chapter 16. .NET and the Coming Revolution

.NET: The Future of Applications Development

On Microsoft Bashing

Microsoft Bigotry?

Part IV: Advanced Topics

Chapter 17. Performance Considerations

Query Optimization

Chapter 18. Debugging and Profiling

Chapter 19. Automation

A Brief Overview of COM

SQL Server and COM Automation

Chapter 20. Extended Stored Procedures

Open Data Services

A Simple Example

A Better Example

Making Extended Procedures Easier to Use

Debugging Extended Procedures

Isolating Extended Procedures

Chapter 21. Administrative Stored Procedures

sp_readtextfile

sp_generate_script

sp_create_backup_job

Chapter 22. Undocumented Transact-SQL

What Defines Undocumented?

Undocumented Procedures

Creating INFORMATION_SCHEMA Views

Creating System Functions

Undocumented DBCC Commands

Undocumented Trace Flags

Chapter 23. Arrays

Array System Functions

The Pièce de Résistance

Multidimensional Arrays

Part V: Essays on Software Engineering

Chapter 24. Creating a Workable Environment

Get Rid of Distractions

Internal Distractions

Form Over Function

Silence Is Golden; Communication Divine

Chapter 25. Evolutionary Development

The Benefits of Small Changes

Software Entropy

Selling Management (or Yourself) on Refactoring

When Not to Refactor

Can You Refactor Instead of Design?

Code Extinction

Extreme Programming

Chapter 26. The Gestalt of Testing

The Futility of Testing

Testing Can Save Time

Testing in the Extreme

Other Types of Testing