SQL Server™ 2005 Bible

Part III. Developing with SQL Server

In This Part

• Chapter 17

• Implementing the Physical Database Schema

• Chapter 18

• Programming with Transact-SQL

• Chapter 19

• Performing Bulk Operations

• Chapter 20

• Kill the Cursor!

• Chapter 21

• Developing Stored Procedures

• Chapter 22

• Building User-Defined Functions

• Chapter 23

• Implementing Triggers

• Chapter 24

• Exploring Advanced T-SQL Solutions

• Chapter 25

• Creating Extensibility with a Data Abstraction Layer

• Chapter 26

• Developing for SQL Server Everywhere

• Chapter 27

• Programming CLR Assemblies within SQL Server

• Chapter 28

• Queueing with Service Broker

• Chapter 29

• Persisting Custom Data Types

• Chapter 30

• Programming with ADO.NET 2.0

• Chapter 31

• Using XML, XPath, and XQuery

• Chapter 32

• Building an SOA Data Store with Web Services

• Chapter 33

• InfoPath and SQL Server 2005

Part II of this book was all about writing set-based queries. This part expands on the select command to provide programmable flow of control to develop server-side solutions; and SQL Server has a large variety of technologies to choose from to develop server-side code—from the mature T-SQL language to .NET assemblies hosted within SQL Server.

Part III opens with DDL commands (create, alter, and drop), and progresses through 9 chapters that dig deeper into Transact-SQL. The conclusion of the T-SQL chapters brings it all together with the data abstraction layer.

SQL Server's list of technologies keeps growing, so the remainder of Part 3 explores the .NET common language runtime (CLR), SQL Server Mobile, Service Broker, XML, XQuery, Web ...