Pro SQL Server 2005 Assemblies

Pro SQL Server 2005 Assemblies

4.11 - 1251 ratings - Source

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, theya€™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. Table of Contents Introducing Assemblies Writing a Simple SQL Assembly The SQL Server .NET Programming Model CLR Stored Procedures User-Defined Functions User-Defined Types User-Defined Aggregates CLR Triggers Error Handling and Debugging Strategies Security Integrating Assemblies with Other TechnologiesCREATE_SERVICE CREATEROUTE CREATEREMOTESERVICEBINDING GRANT_DATABASE CREATE_SECEXPR ALTER_XML_SCHEMA ALTER_PARTITION_FUNCTION ALTER PARTITION SCHEME ALTERSERVICE ALTERROUTEanbsp;...

Title:Pro SQL Server 2005 Assemblies
Author:Robin Dewson, Julian Skinner
Publisher:Apress - 2006-01-03


You Must CONTINUE and create a free account to access unlimited downloads & streaming