Working with CLR User-defined Types

You can create a database object inside SQL Server that is programmed against an assembly created in the Microsoft .NET Framework common language runtime (CLR). Database objects that can take advantage of the rich programming model provided by the CLR include triggers, stored procedures, functions, aggregate functions, and types.

You can extend the SQL type system by defining a custom data type for use in SQL Server programming. A user-defined type (UDT) may be simple or structured and of any degree of complexity. It can encapsulate complex, user-defined behaviors. A user-defined type is implemented as a managed class in any one of the CLR languages, and then registered with SQL Server. A user-defined type can be used to define the type of a column in a table, or a variable or routine parameter in the Transact-SQL language. An instance of a user-defined type can be a column in a table, a variable in a batch, function or stored procedure, or an argument of a function or stored procedure.

The following topics provide additional information about working with user-defined types.

In This Section

Topic

Description

Implementing User-Defined Types

Lists the steps that you require to create or drop a user-defined type, with links to the topics required for completing each step.

Using and Modifying Instances of User-defined Types

Explains how to insert and modify column values and change the values of user-defined type variables and parameters.

Modifying User-defined Type Variable and Parameter Values

Explains how to modify user-defined type variables and parameters in a SET statement or in the SELECT list of a SELECT statement.

Performing Operations on User-defined Types

Explains how to perform a variety of operations on instances of user-defined types.

Using User-defined Types Across Databases

Explains how to convert a user-defined type value from one database for use in another database.

For sample applications that demonstrate how to create and use CLR-based database objects, including user-defined types, in SQL Server, see the CLR Programmability Samples. For information about samples, see Considerations for Installing SQL Server Samples and Sample Databases.

See Also

Concepts