数据库--可编程性--类型--用户定义表类型
select one database--> programmability-->types-->user--defined table types
SQL
-- ================================ -- Create User-defined Table Type -- ================================ USE <database_name,sysname,AdventureWorks> GO -- Create the data type CREATE TYPE <schema_name,sysname,dbo>.<type_name,sysname,TVP> AS TABLE ( <columns_in_primary_key, , c1> <column1_datatype, , int> <column1_nullability,, NOT NULL>, <column2_name, sysname, c2> <column2_datatype, , char(10)> <column2_nullability,, NULL>, <column3_name, sysname, c3> <column3_datatype, , datetime> <column3_nullability,, NULL>, PRIMARY KEY (<columns_in_primary_key, , c1>) ) GO
Query-->Specify values for template parameters