Creating SQL Server 2005 Objects in Managed Code

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.

In This Section

• SQL Server Projects
  Provides an overview of what SQL Server projects are, and the different items that can be created in one.

• Advantages of Using Managed Code to Create Database Objects
  Provides a brief explanation of the benefits of using a .NET language to create SQL Server database objects.

• Attributes for SQL Server Projects and Database Objects
  Provides information on the different attributes used in SQL Server projects.

• How to: Create a SQL Server Project
  Provides detailed steps in creating a new SQL Server project.

• How to: Deploy SQL Server Project Items to a SQL Server
  Provides detailed steps for deploying a SQL Server project to the database.

• How to: Create and Run a CLR SQL Server Stored Procedure
  Provides detailed steps for creating a stored procedure in managed code.

• How to: Create and Run a CLR SQL Server Aggregate
  Provides detailed steps for creating an aggregate in managed code.

• How to: Create and Run a CLR SQL Server Trigger
  Provides detailed steps for creating a trigger in managed code.

• How to: Create and Run a CLR SQL Server User-Defined Function
  Provides detailed steps for creating a user-defined function in managed code.

• How to: Create and Run a CLR SQL Server User-Defined Type
  Provides detailed steps for creating a user-defined type in managed code.

• Item Templates for SQL Server Projects
  Provides information on the different items available for use in SQL Server projects.

• How to: Deploy SQL Server Project Items in Referenced Assemblies
  Provides information for deploying a SQL Server project items located in referenced assemblies to the database.

• Walkthrough: Creating a Stored Procedure in Managed Code
  Provides step by step details for creating a stored procedure in managed code.

Reference

• System.Data
  Describes the System.Data namespace and provides a table of relevant classes.

• System.Data.Sql
  Describes the System.Data.Sql namespace and provides a table of relevant classes.

• System.Data.SqlTypes
  The System.Data.SqlTypes namespace provides classes for native data types within SQL Server 2005.

• Microsoft.SqlServer.Server
  Describes the Microsoft.SqlServer.Server namespace and provides a table of relevant classes.

Related Sections

• How to: Debug a SQL CLR Stored Procedure
  Demonstrates how to debug stored procedures on a SQL Server.

• Walkthrough: Debugging a SQL CLR Trigger
  Demonstrates how to step from a stored procedure into a trigger when it fires.

• Walkthrough: Debugging a SQL CLR User-Defined Aggregate
  Demonstrates how to step into a User Defined Aggregate.

• Walkthrough: Debugging a SQL CLR User-Defined Scalar Function
  Demonstrates how to step into a User Defined Scalar Function.

• Walkthrough: Debug a SQL CLR User-Defined Table-Valued Function
  Demonstrates how to step into a User Defined Table-Valued Function.

• Walkthrough: Debugging a SQL CLR User-Defined Type
  Demonstrates how to step into a User Defined Type.