SQL Server doesn’t have array data types. The closest thing we have is a user defined data type where the type is a table.
Here is the sample code from Books OnLine.
<pre>CREATE TYPE LocationTableType AS TABLE
( LocationName VARCHAR(50)
, CostRate INT )
I have created a temp table as
create table #tempSetIds (Id int)
wherever the user defined type <b>arrayType1</b> was used