OPENXML with xmlns:dt

0

Use OPENXML to get dt element in MSSQL 2005. How can I get xmlns:dt element in xml? For example, get a result set of two rows that list product id and country code. 121403 GBR 121403 USA declare xml     =          DECLARE , varchar()      SET =      EXEC sp_xml_preparedocument OUTPUT, ,        SELECT *      FROM OPENXML(, ,)      WITH ([hm:product_id] , [hm:countries] varchar())      --clean up      EXEC sp_xml_removedocument Here is one solution that I know by using xmlEdgeTable, but I am looking for a better solution. DECLARE , varchar() SET = EXEC sp_xml_preparedocument OUTPUT, ,   CREATE TABLE (     id ,     parentid ,     localname varchar(),     [text] varchar() ) INSERT INTO SELECT id, parentid,localname, cast([text] varchar()) FROM OPENXML(, ,) SELECT t6.text, t2.text FROM                     WHERE t1.localname = t5.localname = --clean up EXEC sp_xml_removedocument DROP TABLE

摘自： http://stackoverflow.com/questions/1440848/openxml-with-xmlnsdt

转载于:https://www.cnblogs.com/wuming/archive/2009/11/24/1609140.html