DECLARE @str VARCHAR(MAX)=
'<?xml version="1.0" encoding="gb2312"?>
10000002
10000001
'
DECLARE @idoc INT
EXEC sys.sp_xml_preparedocument @idoc OUTPUT, @str;
SELECT *
FROM OPENXML(@idoc,'/ArrayOfInt',2) WITH ([int] INT)
EXEC sys.sp_xml_removedocument @idoc
为什么运行结果只有第一个int?