Microsoft SQL Server Creating a UDT with multiple columns


Example

CREATE TYPE MyComplexType as TABLE
(
    Id int,
    Name varchar(10)
)