Part IV. Developing with SQL Server
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.
Get Microsoft® SQL Server® 2008 Bible now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.