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

Introduction

Rather than merely providing a catalog of coding tricks and syntax subtleties, this book teaches the philosophy of Transact-SQL programming and shows you how to apply this philosophy to develop your own coding techniques and solutions to real-world problems. This book takes the position that the “why” is at least as important as the “how” and that a balanced approach to learning Transact-SQL—one that stresses the theoretical as much as it stresses the practical—is preferable to an unbalanced approach.

You'll notice that this book delves into a number of subjects not traditionally associated directly with stored procedure programming. We cover XML, HTML, .NET, and a number of other seemingly ancillary subjects. The reason for this is ...