title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | helpviewer_keywords | |||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Working with User-Defined Types in SQL Server |
You can access UDT functionality in SQL Server from the Transact-SQL language using regular query syntax. Define UDT tables and columns and manipulate UDT data. |
rwestMSFT |
randolphwest |
03/14/2017 |
sql |
clr |
reference |
|
[!INCLUDE SQL Server] You can access user-defined type (UDT) functionality in [!INCLUDEmsCoName] [!INCLUDEssNoVersion] from the [!INCLUDEtsql] language by using regular query syntax. UDTs can be used in the definition of database objects, as variables in [!INCLUDEtsql] batches, in functions and stored procedures, and as arguments in functions and stored procedures.
Defining UDT Tables and Columns
Describes how to use [!INCLUDEtsql] to create a UDT column in a table.
Manipulating UDT Data
Describes how to use [!INCLUDEtsql] to work with UDT data in [!INCLUDEssNoVersion].