Targeted at software developers who want to develop stored procedures without having to deal with the eccentricities of Transact-SQL (T-SQL), this book shows how to build applications using all of the new features of SQL Server 2005. It contrasts the new capabilities available with Managed Stored Procedures (MSPs) against traditional T-SQL.
It addresses creating, updating, and deleting managed stored procedures; converting existing T-SQL to MSPs; integrating MSPs within new and existing database applications; and administration and security. A detailed case example shows how a problem set can now be solved with SQL Server 2005, contrasting this solution with older T-SQL-based methods. The companion Web site provides fully working routines that readers can implement in their own applications.
