This documentation is archived and is not being maintained.

Item Templates for SQL Server Projects 

You can easily add items that are common to SQL Server projects using the Add New Item command. When you use this command, the Add New Item Dialog Box appears with a list of item templates specific to SQL Server projects.

NoteNote

The common language runtime (CLR) integration feature is turned off by default in Microsoft SQL Server and must be enabled in order to use SQL Server project items. To enable CLR integration, use the clr enabled option of the sp_configure stored procedure. From more information, see Enabling CLR Integration.

The following table shows an alphabetical list of templates available for database objects in the Add New Item dialog box when a SQL Server project is open.

Template Description

Stored Procedure

Adds an empty stored procedure to a SQL Server project. For more information, see How to: Create and Run a CLR SQL Server Stored Procedure.

User-Defined Function

Adds an empty scalar-value, user-defined function to a SQL Server project. For more information, see How to: Create and Run a CLR SQL Server User-Defined Function.

User-Defined Type

Adds an empty user-defined type to a SQL Server project. For more information, see How to: Create and Run a CLR SQL Server User-Defined Type.

Trigger

Adds an empty trigger to a SQL Server project. For more information, see How to: Create and Run a CLR SQL Server Trigger.

Aggregate

Adds an empty aggregate function to a SQL Server project. For more information, see How to: Create and Run a CLR SQL Server Aggregate.

Class

Adds an empty class declaration.

Module File

Adds an empty module file.

See Also

Show: