使用主键和具有默认值的列创建 UDT
CREATE TYPE MyUniqueNamesType as TABLE
(
FirstName varchar(10),
LastName varchar(10),
CreateDate datetime default GETDATE()
PRIMARY KEY (FirstName,LastName)
)
CREATE TYPE MyUniqueNamesType as TABLE
(
FirstName varchar(10),
LastName varchar(10),
CreateDate datetime default GETDATE()
PRIMARY KEY (FirstName,LastName)
)