尝试类似的东西
CREATE TABLE #TEMP ( Node int )DECLARE @textXML XMLDECLARE @data NVARCHAr(MAX), @delimiter NVARCHAr(5)SELECt @data = '-1,-1,-1,-1,701,-1,-1,-1,-1,-1,304,390,403,435,438,439,442,455 ', @delimiter = ','SELECT @textXML = CAST('<d>' + REPLACE(@data, @delimiter, '</d><d>') + '</d>' AS XML)INSERT INTO #TEMPSELECT T.split.value('.', 'nvarchar(max)') AS dataFROM @textXML.nodes('/d') T(split)SELECt * FROM #TEMPDROP TABLE #TEMP
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)