OPENXML

Question

OPENXML

VM-723206

SSCrazy

Points: 2964
More actions
June 1, 2009 at 9:54 pm

#205385

Comments posted to this topic are about the item OPENXML

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

SqlOnMyMind SSCertifiable Points: 5062 More actions · Answer 1

Thanks for the interesting example of what happens when you mix attribute-centric and element-centric mapping in one xml structure.

Mauve SSChampion Points: 11316 More actions · Answer 2

The use of XQuery would be better vs. OPENXML which is generally considered to be obsolete. It is more readable which helps to avoid errors.

Additionally, OPENXML is a resource hog. See the SQLServerCentral article:

http://www.sqlservercentral.com/blogs/michael_coles/archive/2008/01/20/stop-using-openxml-please.aspx

[font="Arial Narrow"](PHB) I think we should build an SQL database. (Dilbert) What color do you want that database? (PHB) I think mauve has the most RAM.[/font]

murray-906152 SSCarpal Tunnel Points: 4964 More actions · Answer 3

Answering Carla's question directly - try the following:

SELECT

*

FROM OPENXML (@hdoc, '/test/value',3)

WITH (id int,

name varchar(10),

class int,

flag char(1))

i.e. the flags Argument can be a combination of Byte Values (1 (attribute-centric) and 2 (element-centric))