CREATE TYPE [dbo].[MyTableType] AS TABLE
(
Id INT NULL INDEX ix UNIQUE WHERE Id IS NOT NULL /*Unique ignoring nulls*/
, Sort INT NOT NULL
, [Name] NVARCHAR(MAX) NULL
)
CREATE TYPE [dbo].[MyTableType] AS TABLE
(
CREATE TYPE [dbo].[MyTableType] AS TABLE
(
Id INT NULL INDEX ix UNIQUE WHERE Id IS NOT NULL /*Unique ignoring nulls*/
, Sort INT NOT NULL
, [Name] NVARCHAR(MAX) NULL
)
CREATE TYPE [dbo].[MyTableType] AS TABLE
(