store Procdurex Analysis XML

DECLARE @SearchParamer AS VARCHAR(500);

--SET @SearchParamer='<Params><Param ParamKey="JDTitleKey" ParamValue="111"></Param></Params>'

--SET @SearchParamer='<Params><Param ParamKey="JDTitleKey" ParamValue="111"></Param><Param ParamKey="JDDes" ParamValue="111"></Param></Params>'

SET @SearchParamer='<Params><Param ParamKey="JDDes" ParamValue="111"></Param></Params>'

DECLARE @docHandle INT EXECUTE sp_xml_preparedocument @docHandle OUTPUT, @SearchParamer SELECT      * FROM     OPENXML(@docHandle, '/Params/Param', 1) WITH (         ParamKey VARCHAR(50)  ,          ParamValue VARCHAR(50)  ) EXECUTE sp_xml_removedocument @docHandl