One of the missing language features in T-SQL language is array support. In some cases you can use custom types to work with arrays that are passed as parameters to your stored procedures. Custom types in T-SQL enable you to create alias for some table, .Net or built-in type. Once you create a custom type,... Read more

https://blogs.msdn.microsoft.com/sqlserverstorageengine/2018/07/06/using-custom-types-as-arrays-in-t-sql/