Work with user-defined types in SQL Server
Applies to: SQL Server
You can access user-defined type (UDT) functionality 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
Article | Description |
---|---|
Define user-defined type (UDT) tables and columns | Describes how to use Transact-SQL to create a UDT column in a table. |
Manipulate user-defined type (UDT) data | Describes how to use Transact-SQL to work with UDT data in SQL Server. |