O'Reilly logo

Microsoft® SQL Server® 2008 Bible by Uttam Parui, Mike White, Paul Nielsen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Part IV. Developing with SQL Server

IN THIS PART

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.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required