Code Centric: T-SQL Programming with Stored Procedures and Triggers

If you want to learn how to write stored procedures and triggers for Microsoft SQL Server, Code Centric: T-SQL Programming with Stored Procedures and Triggers is the book for you. You’ll learn “real-world” coding and how to build non-trivial applications. All of the examples covered in the book are available for download, making it easier to work through over 5,000 lines of sample code.

Although there is plenty of coverage of the new functionality in SQL Server 2000, such as UDFs (user-defined functions), you can use this book effectively for virtually any version of SQL Server: 6.x, 7.0 or 2000.

The book starts with a comprehensive overview of Transact-SQL, and goes on to cover various topics, including:

• Data types
• The SELECT statement and JOIN operations
• Control-of-Flow statements
• Updating and deleting data
• Transact-SQL built-in functions
• User-defined functions
• Views

Contents

Forward by William Vaughn

Introduction

Part 1- Transact-SQL Basics

• Chapter 1: Transact-SQL Overview
• Chapter 2: Data Types
• Chapter 3: Data Definition Language
• Chapter 4: Data Manipulation Language: Selecting Data
• Chapter 5: Data Manipulation Language: Inserting/Updating/Deleting Data
• Chapter 6: Built-In Functions
• Chapter 7: User-Defined Functions
• Chapter 8: Views

Part II - Procedures and Triggers

• Chapter 9: System Stored Procedures
• Chapter 10: Extended Stored Procedures
• Chapter 11: User-Defined Stored Procedures
• Chapter 12: Triggers

Part III - Putting SQL to Work

• Chapter 13: Procedures and Triggers by Example
• Chapter 14: Building an Application

Chapter 15: Appendixes

• A: HTML Primer
• B: ASP Primer
• C: Query Optimization/Performance Tuning Primer
• D: XML