|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
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
Describes how to use Transact-SQL to create a UDT column in a table.
Describes how to use Transact-SQL to work with UDT data in SQL Server.