You can use .NET languages in addition to the Transact-SQL programming language to create database objects such as stored procedures and triggers, and to retrieve and update data for Microsoft SQL Server 2005 databases.
Provides an overview of what SQL Server projects are, and the different items that can be created in one.
Provides a brief explanation of the benefits of using a .NET language to create SQL Server database objects.
Provides information on the different attributes used in SQL Server projects.
Provides detailed steps in creating a new SQL Server project.
Provides detailed steps for deploying a SQL Server project to the database.
Provides detailed steps for creating a stored procedure in managed code.
Provides detailed steps for creating an aggregate in managed code.
Provides detailed steps for creating a trigger in managed code.
Provides detailed steps for creating a user-defined function in managed code.
Provides detailed steps for creating a user-defined type in managed code.
Provides information on the different items available for use in SQL Server projects.
Provides information for deploying a SQL Server project items located in referenced assemblies to the database.
Provides step by step details for creating a stored procedure in managed code.
Describes the System.Data namespace and provides a table of relevant classes.
Describes the System.Data.Sql namespace and provides a table of relevant classes.
The System.Data.SqlTypes namespace provides classes for native data types within SQL Server 2005.
Describes the Microsoft.SqlServer.Server namespace and provides a table of relevant classes.
Demonstrates how to debug stored procedures on a SQL Server.
Demonstrates how to step from a stored procedure into a trigger when it fires.
Demonstrates how to step into a User Defined Aggregate.
Demonstrates how to step into a User Defined Scalar Function.
Demonstrates how to step into a User Defined Table-Valued Function.
Demonstrates how to step into a User Defined Type.
Refer to my blog for helpful advice on SQL CLR development.Jeff Fischer