Transact-SQL Instances Encyclopedia

Author: Zhang Pingzong
Publisher:
Publish Date: 2002-01-01
Features: This book comprehensively introduces the application development techniques of Transact-SQL through examples. The entire book consists of 11 chapters. The first two chapters mainly cover the basic usage and programming concepts of Transact-SQL. Chapter 3 demonstrates the use of built-in functions. Chapters 4, 5, and 6 respectively show how to use cursors, stored procedures, and triggers. Chapters 7, 8, and 9 introduce three topics: indexes, the ADO model, and replication, respectively. Chapter 10 demonstrates some methods for query optimization. Chapter 11 focuses on the use of XML in databases. Each chapter is composed of multiple examples, with each example divided into three parts: "Example Objective," "Source Code," and "Code Analysis," making it clear and easy to learn.