Apress Access

Pro SQL Server 2005 Assemblies

By Robin Dewson , Julian Skinner

  • eBook Price: $34.99
Buy eBook Buy Print Book

Pro SQL Server 2005 Assemblies Cover Image

Pro SQL Server 2005 Assemblies will show you how to exploit the new .NET capabilities of the SQL Server 2005 database. You will learn how to build robust, useful, and intelligent assemblies that are safe to execute and secure to the organization.

Full Description

  • Add to Wishlist
  • ISBN13: 978-1-59059-566-4
  • 296 Pages
  • User Level: Beginner to Advanced
  • Publication Date: January 3, 2006
  • Available eBook Formats: PDF

Related Titles

  • High Performance SQL Server
  • Expert Scripting and Automation for SQL Server DBAs
  • Beginning SQL Server R Services
  • Securing SQL Server
Full Description

Pro SQL Server 2005 Assemblies provides a detailed and example-driven tutorial on how to build and use .NET assemblies. The authors focus on building assemblies in C#, but also provide the equivalent VB .NET code in the supplied code download.

Assemblies are not a complete replacement for T-SQL stored procedures and triggers; rather, they’re enhancements, to be used at the right place and right time. This book examines the ins and outs of assemblies when they should and should not be used, what you can do with them, and how you can get the most out of them.

What you’ll learn

  • Setting up a site in Dreamweaver
  • Global web site essentials, such as dealing with doctypes, meta tags, comments, and page defaults, and attaching CSS and JavaScript files to your page
  • Styling page content properly using CSS
  • Working with images
  • Creating web site navigation
  • CSS for impressive page layouts that work
  • Getting user feedback via forms

Following these exercises, the book then shows how to bring everything together with a final case study using Dreamweaver to build a complete web site.

Table of Contents

Table of Contents

  1. Introducing Assemblies
  2. Writing a Simple SQL Assembly
  3. The SQL Server .NET Programming Model
  4. CLR Stored Procedures
  5. User-Defined Functions
  6. User-Defined Types
  7. User-Defined Aggregates
  8. CLR Triggers
  9. Error Handling and Debugging Strategies
  10. Security
  11. Integrating Assemblies with Other Technologies
Source Code/Downloads

Downloads are available to accompany this book.

Your operating system can likely extract zipped downloads automatically, but you may require software such as WinZip for PC, or StuffIt on a Mac.


If you think that you've found an error in this book, please let us know by emailing to editorial@apress.com . You will find any confirmed erratum below, so you can check if your concern has already been addressed.

On page 149 and 153:

loop definition increments by 3, but I think it should increment by 1. Existing Code:
for (int i=0; i<arrActions.Length;i+=3).

Should be i+=1


    1. Pro SQL Server Wait Statistics


      View Book

    2. SQL Server T-SQL Recipes


      View Book

    3. Entity Framework 6 Recipes


      View Book

    4. Healthy SQL


      View Book