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

Front Cover
Addison-Wesley Professional, 2002 - Computers - 774 pages

SQL Server developers worldwide raved about Ken Henderson's The Guru's Guide to Transact-SQL: its exceptionally clear, conversational explanations, and its powerfully useful projects and code examples. This book helps SQL Server developers take the next step -- building more powerful, robust applications than ever before. Henderson identifies several key areas of SQL Server development that offer the greatest power -- and then covers each of them in exceptional detail. The book includes especially thorough coverage of Transact-SQL stored procedure programming, including features such as extended procedures, database design, and XML that are often disregarded in competitive books. Henderson introduces a method he has developed to add arrays to T-SQL, something previously thought impossible. He offers an ideal balance of theory and code, gradually building on basic techniques to create increasingly sophisticated solutions, and teaching the philosophy of Transact-SQL programming alongside syntax and technique. An accompanying CD-ROM includes extensive source code, including valuable proprietary code that makes T-SQL queries run faster. For every SQL Server developer.

 

What people are saying - Write a review

We haven't found any reviews in the usual places.

Contents

Chapter
3
Chapter
4
Chapter
8
PART IllHTML XML AND NET 337
11
Chapter
15
Chapter
20
Source Formatting
50
Coding Conventions
64
Schemas
367
Summary
380
Template Queries
393
EXPLICIT Mode
406
NET and the Coming Revolution
459
On Microsoft Bashing
474
Debugging
513
Summary
528

General Approach
121
EntityRelationship Modeling
143
Relational Data Modeling
162
Chapter 23
170
Summary
181
Speed
197
Metadata
245
Updatable Views
265
Indexed Views
286
Metadata
300
Introduction to XML
353
Sp_readtextfile
585
Sp_start trace
602
SP_0ſOC_ſunner
617
Creating INFORMATION_SCHEMA Views
655
Undocumented Trace Flags
671
Array System Functions
689
PART VESSAYS ON SOFTWARE ENGINEERING
701
Software
714
Conclusion
732
Testing in the Extreme
740
Copyright

Other editions - View all

Common terms and phrases

About the author (2002)

Ken Henderson, a nationally recognized consultant and leading DBMS practitioner, consults on high-end client/server projects for such customers as the U.S. Air Force, the U.S. Navy, H&R Block, Travelers Insurance, J.P. Morgan, the CIA, Owens-Corning, and CNA Insurance. He is the author of five previous books on client/server and DBMS development, a frequent magazine contributor to such publications as Software Development Magazine and DBMS Magazine, and a speaker at technical conferences.



0201700468AB07032003

Bibliographic information