SQL Server 2使用自定义表类型

参考：

https://www.cnblogs.com/51net/archive/2013/03/06/2945602.html

https://blog.csdn.net/crystal4000/article/details/129137751

查看自定义表类型

SELECT * FROM sys.types WHERE is_table_type = 1;

 

查看自定义表类型有哪些字段

select a.name,b.name
from sys.table_types a join sys.syscolumns b
on a.type_table_object_id=b.id where a.name='tvpMenus'