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.