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

ISBN-10: 0201700468
ISBN-13: 9780201700466
Edition: 2002
Authors: Ken Henderson
List price: $69.99
30 day, 100% satisfaction guarantee

If an item you ordered from TextbookRush does not meet your expectations due to an error on our part, simply fill out a return request and then return it by mail within 30 days of ordering it for a full refund of item cost.

Learn more about our returns policy

Description: 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  More...

what's this?
Rush Rewards U
Members Receive:
coins
coins
You have reached 400 XP and carrot coins. That is the daily max!
You could win $10,000

Get an entry for every item you buy, rent, or sell.

Study Briefs

Limited time offer: Get the first one free! (?)

All the information you need in one place! Each Study Brief is a summary of one specific subject; facts, figures, and explanations to help you learn faster.

Add to cart
Study Briefs
SQL Online content $4.95 $1.99
Add to cart
Study Briefs
MS Excel® 2010 Online content $4.95 $1.99
Add to cart
Study Briefs
MS Word® 2010 Online content $4.95 $1.99
Add to cart
Study Briefs
MS PowerPoint® 2010 Online content $4.95 $1.99

Customers also bought

Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading

Book details

List price: $69.99
Copyright year: 2002
Publisher: Addison Wesley Professional
Publication date: 12/27/2001
Binding: Paperback
Pages: 800
Size: 7.25" wide x 9.00" long x 1.50" tall
Weight: 2.640
Language: English

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.

Foreword
Preface
Introduction
The Basics
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
Parameters
Flow Control Language
Errors
Nesting
Recursion
Summary
Suggested Conventions
Source Formatting
Coding Conventions
Summary
Common Design Patterns
The Law of Parsimony
Idioms
Design Patterns
Summary
Source Code Management
The Benefits of Source Code Management
The dt Procedures
Best Practices
Version Control from Query Analyzer
Automating Script Generation with Version Control
Summary
Database Design
General Approach
Modeling Tools
The Sample Project
The Five Processes
The Five Phases Examined
Defining the Functions of the Application
Modeling Business Processes
Entity-Relationship Modeling
Relational Data Modeling
Summary
Data Volumes
Approaches to Generating Data
Speed
Summary
Objects
Error Handling
Error Reporting
Handling Errors
Summary
Triggers
Determining What Has Changed
Managing Sequential Values
Trigger Restrictions
Instead of Triggers
Triggers and Auditing
Transactions
Execution
Calling Stored Procedures
Nested Triggers
Disabling Triggers
Best Practices
Summary
Views
Meta-data
Restrictions
Ansi SQL Schema Views
Updatable Views
The With Check Option Clause
Derived Tables
Parameterized Views
Dynamic Views
Partitioned Views
Indexed Views
Designing Modular Indexed Views
Summary
User-Defined Functions
Scalar Functions
Table-Value Functions
Inline Functions
Limitations
Meta-data
Creating Your Own System Functions
UDF Cookbook
Summary
HTML, XML, and .NET
HTML
Origins
Producing HTML from Transact-SQL
Producing HTML from sp_makewebtask
Summary
Introduction to XML
Wooden Nickels
XML: An Overview
HTML: Simplicity Comes at a Price
XML: A Brief History
XML versus HTML: An Example
Document Type Definitions
XML Schemas
Extensible Stylesheet Language Transformation (XSLT)
Document Object Model
Further Reading
Tools
Summary
XML and SQL Server: HTTP Queries
Accessing SQL Server over HTTP
URL Queries
Template Queries
Summary
XML and SQL Server: Retrieving Data
Select...For XML
RAW Mode
AUTO Mode
Elements
Explicit Mode
Mapping Schemas
Summary
XML and SQL Server: OPENXML
The Flags Parameter
Edge Table Format
Inserting Data with OPENXML()
Web Release 1
Limitations
Summary
.NET and the Coming Revolution
.NET: The Future of Applications Development
What Is .NET?
On Microsoft Bashing
Microsoft Bigotry?
Summary
Advanced Topics
Performance Considerations
Indexing
Statistics
Query Optimization
Summary
Debugging and Profiling
Debugging
Profiling
Stress Testing
Summary
Automation
A Brief Overview of COM
SQL Server and COM Automation
Summary
Extended Stored Procedures
Open Data Services
A Simple Example
A Better Example
Making Extended Procedures Easier to Use
Debugging Extended Procedures
Isolating Extended Procedures
xp_setpriority
Summary
Administrative Stored Procedures
sp_readtextfile
sp_diff
sp_generate_script
sp_start_trace
sp_stop_trace
sp_list_trace
sp_proc_runner
sp_create_backup_job
sp_diffdb
Summary
Undocumented Transact-SQL
What Defines Undocumented?
Undocumented Procedures
Creating Information_Schema Views
Creating System Functions
Undocumented DBCC Commands
Undocumented Functions
Undocumented Trace Flags
Summary
Arrays
xp_array.dll
Array System Functions
The Piece de Resistance
Multidimensional Arrays
Summary
Essays on Software Engineering
Creating a Workable Environment
Get Rid of Distractions
Close the Door
Internal Distractions
Form Over Function
Silence Is Golden; Communication Divine
Conclusion
Epilogue
Evolutionary Development
Kaizen
The Benefits of Small Changes
Software
Software Eutropy
Refactoring
Selling Management (or Yourself) on Refactoring
When Not to Refactor
Databases
Can You Refactor Instead of Design?
A House Built Upon the Sand
Extreme Programming
Conclusion
Epilogue
The Gestalt of Testing
Where to Begin
The Futility of Testing
Types of Tests
When to Test
Testing Can Save Time
Testing in the Extreme
Other Types of Testing
Conclusion
Epilogue
References
Index

×
Free shipping on orders over $35*

*A minimum purchase of $35 is required. Shipping is provided via FedEx SmartPost® and FedEx Express Saver®. Average delivery time is 1 – 5 business days, but is not guaranteed in that timeframe. Also allow 1 - 2 days for processing. Free shipping is eligible only in the continental United States and excludes Hawaii, Alaska and Puerto Rico. FedEx service marks used by permission."Marketplace" orders are not eligible for free or discounted shipping.

Learn more about the TextbookRush Marketplace.

×