I am writing a SQL Stored Proc which takes in a single table valued parameter. Is it possible for me to create the table type in the parameter definition, for example:
CREATE PROCEDURE example (
@param (CREATE TYPE tableparameter ( column1 int, colunn2 varchar.... )) READONLY
)