SELECT CONVERT(INT,value) FROM STRING_SPLIT(CONVERT(VARCHAR(MAX),‘1,2,3,4,5,6,7,8,9‘),‘,‘)
Sqlserver字符串拆分
原文:https://www.cnblogs.com/Newd/p/14769437.html