SQL Server 2008

Programming with CLR and .NET

• Basics
• Security
• Stored procedures
• Trigger (DML and DDL)
• Scalar functions
• Table value functions
• Aggregates
• User-defined types
• Deployment
• Many practical examples

In four clearly arranged parts, this book covers the database programming with SQL Server 2008 with the help of the integrated .NET CLR (Common Language Runtime)

The first part explains the basics required for effective programming, with an emphasis on the items security and deliberations on reasonable use.

Based upon this, the second part, using practical examples, shows how to develop saved procedures, triggers, functions, and user-defined types using .NET for SQL Server.

The third part covers integration into effective, practical applications.

Finally, the fourth part demonstrates how to work with the types HIERARCHYID, GEOGRAPHY and GEOMETRY, which Microsoft themselves developed with .NET.