sp_xml_preparedocument的使用...
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
DECLARE @ParameterXml as VARCHAR(200)
SET @ParameterXml=' <parameters><parameter id="123058" value="85|90"></parameter><parameter id="123059" value="blue"></parameter></parameters>'
declare @docid int
EXEC sp_xml_preparedocument @docid OUTPUT, @ParameterXml
SELECT *
FROM
OPENXML(@docid, '/parameters/parameter', 1)
WITH
(
ParameterID int '@id',
ParameterValue NVarchar(512) '@value'
) as a