IN THIS PART
Chapter 20: Creating the Physical Database Schema
Chapter 21: Programming with T-SQL
Chapter 22: Kill the Cursor!
Chapter 23: T-SQL Error Handling
Chapter 24: Developing Stored Procedures
Chapter 25: Building User-Defined Functions
Chapter 26: Creating DML Triggers
Chapter 27: Creating DDL Triggers
Chapter 28: Building the Data Abstraction Layer
Chapter 29: Dynamic SQL and Code Generation
Part II of this book was all about writing set-based queries. Part III extended the
select command to data types beyond relational. This part continues to expand on
select 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.
This part opens with DDL commands (
create, alter, and
drop), and progresses through 10 chapters of Transact-SQL that build on one another into a crescendo with the data abstraction layer and dynamic SQL. The final chapter fits CLR programming into the picture.
So, unleash the programmer within and have fun. There's a whole world of developer possibilities with SQL Server 2005.
If SQL Server is the box, then Part IV is all about thinking inside the box, and moving the processing as close to the data as possible.