Export (0) Print
Expand All
3 out of 10 rated this helpful - Rate this topic

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.