Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Important This document may not represent best practices for current development, links to downloads and other resources may no longer be valid. Current recommended version can be found here.

Working with User-Defined Types in SQL Server 

.NET Framework 2.0

User-defined type (UDT) functionality can be accessed in 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.

See Also

Community Additions

© 2015 Microsoft