Answered Question

darth con...

M$1 December 31, 2008 04:43 PM

In MS SQL 2005, is there a way to determine whether a specific node exists in an XML variable?

For example, say I have the following XML:

.... [parentNode]

........ [test1][/test1]
........ [test2][/test2]

........ [subNode]
............ [subTest1]123[/subTest1]
............ [subTest2]234[/subTest2]
........ [/subNode]

.... [/parentNode]

Once I load the XML into a variable, there will be instances when [subNode] may or may not exist. What's a straightforward method to detect whether [subNode] is present?

Interesting Question? Yes (0) No (0)

RSS

Best Answer Chosen by Asker

ilaksh

January 01, 2009 07:23 AM

Wait, I thought you were doing it in 2000? Anyway, something like this:

RETURN (SELECT @xmlData.exist('/parentNode/subNode'))

you might have to mess with the xpath query a little depending on the exact structure but I am pretty sure something like that will work.
Source(s):
http://msdn.microsoft.com/en-us/library/ms345117.aspx (under heading Example: Constraining XML Column)

Asker's Rating:

Helpful Answer?

(0)

(0) Tip ilaksh for this answer

Permalink | Report

darth cont...

January 01, 2009 07:37 AM

Thanks; this issue actually I can use the features of 2005 with. The one related to the other question I can't because of time constraints; the time it'd take to change all the underlying code to use 2005's better XML functionality will have to wait until a deadline of mine has passed.

Tip darth continent for this comment

Report

Answer this Question

Ask a Question

Top of Page

Buy Mahalo Dollars with Credit Card or PayPal

Top Members

This Week All Time

cfinke
2nd Degree Black Belt
27330 Points
M$29.75 Earned
bunnyphuph...
2nd Degree Black Belt
21386 Points
M$762.89 Earned
opher
Purple Belt with a Brown Tip
6142 Points
M$238.49 Earned

See All

Most Popular Tags

mahalo(1800)

twitter(979)

music(495)

iphone(485)

google(392)

online(369)

food(340)

internet(311)

beer(287)

money(284)

movies(281)

facebook(276)

apple(259)

answers(245)

aotd(235)

free(233)

health(228)

video(224)

dog(217)

windows(211)

See All

Welcome New Members

joujord, December 11, 2009 04:20 PM
jordanaribeirod..., December 11, 2009 04:19 PM
naked_lindsay, December 11, 2009 04:16 PM
jmartpolitico, December 11, 2009 04:14 PM
govardspacer, December 11, 2009 03:53 PM

Mahalo Dollars are the currency of Mahalo Answers.

Each Mahalo Dollar costs $1.

Once you earn more than 40 Mahalo Dollars, you can request to be paid via PayPal. Each Mahalo Dollar is currently worth $0.75 when paid out via PayPal. Learn More