How to Create an array or 2 columns table using select - select from list of values - row/column constructor

----------------Syntax---------------------------

SELECT 
  *
FROM
  (
    Values
        ( ValueForField1, ValueForField2,..., ValueForFieldN ),
        ( ValueForField1, ValueForField2,..., ValueForFieldN ),
        ( ValueForField1, ValueForField2,..., ValueForFieldN ),
        ( ValueForField1, ValueForField2,..., ValueForFieldN ),
        ( ValueForField1, ValueForField2,..., ValueForFieldN )
  ) AS TempTableName ( FieldName1, FieldName2, ..., FieldNameN )

-------------------Example-------------------

select * from (values ('1',2),('2',3) ) as a (datacol,datacol2)

Or same simmilar array could be built using below method


SELECT * FROM (VALUES('Row1'),('Row2'),('Row3')) as tbl1 ([ColumnFieldName1])
,(VALUES('NoOfColumns1'),('NoOfColumns2')) AS z([ColumnName2])