This topic has not yet been rated - Rate this topic

Working with User-Defined Types in SQL Server

SQL Server 2008

SQL Server 2008 R2
SQL Server 2005
SQL Server 2012

You can access user-defined type (UDT) functionality in Microsoft SQL Server from the Transact-SQL language by using regular query syntax. UDTs can be used in the definition of database objects, as variables in Transact-SQL batches, in functions and stored procedures, and as arguments in functions and stored procedures.

In This Section

Defining UDT Tables and Columns: Describes how to use Transact-SQL to create a UDT column in a table.
Manipulating UDT Data: Describes how to use Transact-SQL to work with UDT data in SQL Server.

Concepts

CLR User-Defined Types

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD