Convert a separator string to a temporary table in SQL

Problem: It is required to convert each content separated by a string 0, 1, 2, 3, 4, 5 into a row and record it in the database table.
Declare @ table _ string-to-array table (adapt_object int default 0)
Declare @ tmp_str varchar (100)
Declare @ tmp_index int
Select @ tmp_index = 1
Select @ tmp_str = '0, 03,4, 5, a, '-- assign test value
While (@ tmp_index> 0)
Begin
Select @ tmp_index = CHARINDEX (',', @ tmp_str) --, which is a separator
If (@ tmp_index> 0)
If (ISNUMERIC (substring (@ tmp_str, 1, @ tmp_index-1) = 1) -- only put data of the number type after separation and conversion to the temporary table
Insert into @ table _ string-to-array (adapt_object)
Select convert (int, substring (@ tmp_str, 1, @ tmp_index-1 ))
Select @ tmp_str = substring (@ tmp_str, @ tmp_index + 1,100)
End
Select * from @ table _ string-to-array