One of the weaknesses of Microsoft SQL Server is its lack of array types, and the difficulty of implementing array-like functionality such…