Split string into multiple columns in SQL Server

Today to change to the old man's code, actually put multiple IDs in a column, or use the comma partition ... What do you do when you inquire???

Search the internet for half a day, finally found a SQL Server inside there is a parsename function, you can press. (dot) to split the string,

So I wrote down the following SQL

SELECT ParseName (REPLACE(fromagentids,',','). '),1 as one,parsename(REPLACE(fromagentids,',  ','. '),3 as from

Query results

Reference article: http://www.cnblogs.com/huangshuqiang/archive/2016/05/10/5477385.html

Split string into multiple columns in SQL Server