Transact-SQL Programming
Customer Reviews: 5 Average Customer Rating:   Write a Review and tell the world about this title! People who purchase this book frequently purchase: Books on similar topics, in best-seller order:Books from the same publisher, in best-seller order:
Transact-SQL is a procedural language used on both Microsoft SQL Server
and Sybase SQL Server systems. It is a full-featured programming
language that dramatically extends the power of SQL (Structured Query
Language).
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 fields
- Local and global variables
- Fully programmable server objects like views, triggers, stored
procedures, and batch command files
- Conditional processing
- Exception and error handling
- Full transaction control
- System stored procedures that reduce the complexity of many
operations, like adding users or automatically generating HTML
Web pages
In 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.5 and 7.0 and Sybase version 11.5.
A brief table of contents follows:
PART I: The Basics: Programming in Transact-SQL
1. Introduction to Transact-SQL
2. Matching Business Rules
3. SQL Primer
4. Transact-SQL Fundamentals
5. Format and Style
PART II: The Building Blocks: Transact-SQL Language Elements
6. Datatypes and Variables
7. Conditional Processing
8. Row Processing with Cursors
9. Error Handling
10. Temporary Objects
11. Transactions and Logging
PART III: Functions and Extensions
12. Functions
13. CASE Expressions and Transact-SQL Extensions
PART IV: Programming Transact-SQL Objects
14. Stored Procedures and Modular Design
15. Triggers
16. Views
17. System and Extended Stored Procedures and BCP
PART V: Performance Tuning and Optimization
18. Transact-SQL Code Design
19. Code Maintenance in the SQL Server
20. Transact-SQL Optimization and Tuning
21. Debugging Transact-SQL Programs
PART VI: Appendixes
A. System Tables
B. What's New for Transact-SQL in Microsoft SQL Server 7.0?
C. BCP
The book comes with a CD-ROM containing an extensive set of
examples from the book and complete programs that illustrate
the power of the language.
Table of Contents
Foreword
Preface
I. The Basics: Programming in Transact-SQL
1. Introduction to Transact-SQL
SQL and the Introduction of Transact-SQL
The Relational Database Model
Normalization
Row Processing Versus Set Processing
The History of SQL Server
What Is Transact-SQL?
Summary
2. Database Analysis and Design
The Need for Adequate Analysis and Design
The Systems Life Cycle
Overview of Analysis
Overview of Design
Putting it Together with CASE Technology
Summary
3. SQL Primer
SQL Versus Transact-SQL
Data Definition Language
Data Manipulation Language
Summary
4. Transact-SQL Fundamentals
Server Character Sets
Server Sort Orders
Identifiers
Foundation Units
Executing Transact-SQL
The GO Statement
Transact-SQL Batches
Summary
5. Format and Style
Why Bother?
What Is a Good Coding Style?
Case of Keywords and User-Defined Names
Naming Conventions and Abbreviations
Standard Error Handling
Style Odds and Ends
Formatting DML and DDL Statements
Formatting Transaction Blocks and Procedural Blocks
Commenting Your Code
Summary
II. The Building Blocks: Transact-SQL Language Elements
6. Datatypes and Variables
Datatypes
User-Defined Datatypes
Processing Nulls
Variables
Parameters
Summary
7. Conditional Processing
BEGIN . . . END Constructs
IF Constructs
GOTO Branching and Error Handling
WAITFOR Construct
WHILE Loops
RETURN Statement
Summary
8. Row Processing with Cursors
Cursor Fundamentals
Declaring a Cursor
Opening a Cursor
Asynchronous Keysets
Fetching Data
Closing and Deallocating a Cursor
Working with Cursors
Performance Issues for Cursors
Summary
9. Error Handling
Code Processing and Error Handling: Basic Concepts
Displaying an Error Message with PRINT
Raising an Error with RAISERROR
Finding Error Conditions with Global Variables
Handling Errors with GOTO
Creating Specialized Error Messages
Finding Error Messages in Operating System Files
Summary
10. Temporary Objects
Creating and Manipulating TemporaryObjects
The tempdb Database
Classes of Temporary Objects
Query Optimization with Temporary Tables
Management of the tempdb Database
Summary
11.
and Locking 297
About Transactions
Locking
Transactions and the Database
Summary
III. Functions and Extensions
12. Functions
Aggregate Functions
Mathematical Functions
String Functions
Date Functions
Text and Image Functions
Type Conversion Functions
System Functions
Summary
13. CASE Expressions and Transact-SQL Extensions
CASE Expressions
COMPUTE
CUBE and ROLLUP
Summary
IV. Programming Transact-SQL Objects
14. Stored Procedures and Modular Design
About Stored Procedures
CREATE PROCEDURE
Types of Stored Procedures
Advantages of Stored Procedures
Stored Procedures Versus Other Objects
Executing Stored Procedures
Remote Procedure Calls (RPCs)
Stored Procedure Design
Conditional Data Retrieval
Data Formatting
Data Security and Encryption
Performance Issues
Summary
15. Triggers and Constraints
Triggers
Interaction of Triggers and Constraints
Summary
16. Views
About Views
Managing Views
Querying Views
View Dependencies, Permissions, and Data Manipulations
Limitations of Views
View Overhead
Summary
17. System and Extended Stored Procedures
System Stored Procedures
Common System Stored Procedures
Extended Stored Procedures
Summary
V. Performance Tuning and Optimization
18. Transact-SQL Code Design
Coding for Reuse
The Black Box Program
Categorization Schemas
RETURN
RAISERROR
Temporary Data Storage
Using Parameters Effectively
Help
Summary
19. Code Maintenance in SQL Server
Using SQL Server System Tables
Interdependence of Server-Side Objects
Source Code Management
Code Maintenance
Related Topics
Summary
20. Transact-SQL Optimization and Tuning
About Optimization
Efficient Physical Database Design
Indexing Strategies
SQL Server Query Optimizer
SHOWPLAN Output
Optimizer Hints
Query Analysis
Optimization Tips and Techniques
Summary
21. Debugging Transact-SQL Programs
Testing Versus Debugging
Successful Debugging
Specific Debugging Techniques
The SET Command
Debugging Utilities
Summary
VI. Appendixes
A. System Tables
B. What's New for Transact-SQL in Microsoft SQL Server 7.0
C. The BCP Utility
Customer Reviews
Customer Reviews: 5 Average Customer Rating: Feb 21, 2001
Coverage is more geared toward SQL Server 6.5
Great book, but be careful because some of the coverage is quite outdated. There is an apendix that has features of SQL Server 7, but main text body refers to 6.5. This fact bit me once or twice, but otherwise book is very good.
Oct 4, 2000
Best book on T-SQL
I think this is the best book out there on T-SQL. There may be other good SQL Server books, but this is a great book if you want to write stored proceedures or triggers.
Sep 7, 2000 A review from Colorado
Great Book for SQL 6.5
This is a great book if you are using SQL 6.5: great explanations and examples. I would not recommend this book, if you want to learn SQL 7. When this book was written, it was giving you a taste of what was to come with SQL 7.
Nov 15, 1999 A review from Rio de Janeiro, Brazil
Doesn't cover SQL Server 7.0
Pay attention to Table of Contents. This book is about version 6.5 of SQL Server. The treatment of version 7.0 is just a few pages in an appendix!
This is misleading ...
Jul 30, 1999 Thomas Holden from Duluth, MN
This is an excellent resource for SQL Server 6.5 and 7.0.
This is the best book I've found on writing Transact-SQL code. It is great for database developers and application programmers. Well organized, and has many code examples. Great help in writing procedures, triggers, and understanding the SQL Server.
|
