SQL Server imports an array to the stored procedure

Suppose I have an array: A (1) = 111, A (2) = 222, A (3) = 333 ......
W I want to pass the array into the stored procedure, but sqlserver does not support arrays. Search for Baidu and find a strong method:
1. First convert the array into a string separated by commas ,...... '
2. Convert the string into a SELECT statement connected with union:
Select '000000' as a Union select '000000' as a Union select '000000' as a Union select '000000' as ......
The statement returns the following results:
A
----------
111
222
333
444
.
.
.
.

Insert the result to the temporary table.

Declare @ string varchar (80)
Declare @ sqlstr2table varchar (1000)

Set @ string = '000000'

Set @ sqlstr2table = 'select' + Replace (@ string, ',', ''' as caller_id Union select ''') + ''''
Exec (@ sqlstr2table)