Is it possible to query any text on xmldata of sqlserver 2005 table?
-
I am querying like below SELECT XMLData.query('"title"') FROM XMLTable on an sql server database's xmlTable's XMLData of xmltype field. But it alway returning the string "title" for all the records in the table. Is it not possible to query like the above ? Please suggest something.
-
I am querying like below SELECT XMLData.query('"title"') FROM XMLTable on an sql server database's xmlTable's XMLData of xmltype field. But it alway returning the string "title" for all the records in the table. Is it not possible to query like the above ? Please suggest something.
i've never used sql server xml functionality, but it looks like you're using wrong syntax. execution the xpath "'title'" will always return "title", so you may need to modify your xpath expression. what's a sample content of your xmltype field?
-
i've never used sql server xml functionality, but it looks like you're using wrong syntax. execution the xpath "'title'" will always return "title", so you may need to modify your xpath expression. what's a sample content of your xmltype field?
-
Actually i want to search the string "title" at any location through out the complete xml data. what is the way to frame the query? Plese help.
so there is some xml data with 0, 1 or more occurances of "title" anywhere? okay..but what do you expect your query to return?