SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by diego.perdices / XML Query / Latest Posts

RE: XML Query

L' Eomot Inversé — Sat, 20 Mar 2010 11:29:31 GMT

Oh :blush:! I answered "which of the queries posted below [b];doesn't[/b]; return...";-). I guess I'd forgotten what the question was by the time I worked out what each of the four queries would do.I hate xml, and FOR XML - all that fashionable junk - so it takes me a very very very long time (the first hour or two persuading myself that I really will look at something with XML in it:hehe:) to decipher a query with FOR XML in it.edit: change < and > to [ and ]. Whose idea was sqare brackets for presentation markup, anyway?

RE: XML Query

Muhammed Rafiq — Thu, 29 Oct 2009 01:34:48 GMT

Me too get same result for all 4 options

RE: XML Query

Stefano Bozzoni — Tue, 13 Oct 2009 01:54:52 GMT

Quiz doesn't work at all booooh!!

RE: XML Query

Damian Widera-396333 — Fri, 09 Oct 2009 01:08:57 GMT

The third query gives other result than first tree - look at the element names

RE: XML Query

setiv — Wed, 07 Oct 2009 12:31:31 GMT

When querying A (SQLServer2005, SQLServer2005_SSMSEE) displays:"<customers><customers id="6"><customers customer="Victoria"/></customers><customers id="2"><customers customer="Lyss"/></customers><customers id="1"><customers customer="John"/></customers><customers id="3"><customers customer="Jack"/></customers><customer"This may be the result of installation of incomplete version(SQLServer2005, SQLServer2005_SSMSEE) What Kit you can recommend?

RE: XML Query

KevinC. — Wed, 07 Oct 2009 11:25:29 GMT

Setiv: You can also set Tools -> Options... -> Query Results -> Results to File and save the file as a text document (change the file type to All Files). However, I do recommend mtassin's suggestion over the Results to File option. Still, it's good to know all of your options so as to make a better decision.--KevinC.

RE: XML Query

mtassin — Wed, 07 Oct 2009 10:52:21 GMT

Setiv,also open Tools -> Options -> Results to text and set the maximum length to a value higher than 256. I set mine to 4000 which works wonderfully :)

RE: XML Query

setiv — Wed, 07 Oct 2009 10:02:51 GMT

This will not help. I need to buy a new computer.

RE: XML Query

mtassin — Wed, 07 Oct 2009 09:48:17 GMT

Sanjay is right.... it got me because I wasn't reading clearly.[code]<customersa customers.id="6">[/code]Is not the same as [code]<customers customers.id="6">[/code] :) Good question... shows me why I hate xml as much as I do :)

RE: XML Query

SanjayAttray — Wed, 07 Oct 2009 08:50:36 GMT

[quote][b]lucky-80472 (10/7/2009)[/b][hr]I'm getting the same result for all the 4 queries posted.anybody else?[/quote]you see alias customersa and customersb in the resultset of C. where as in all other queries it's customers.

RE: XML Query

SanjayAttray — Wed, 07 Oct 2009 08:49:23 GMT

I am bad at XML, actually very bad. Have to execute each code in SSMS and then see the difference.But still, what acually is different in C except that you see alias customersa and customersb, where as results are same and what is common between A, B and D queries ?May be a person with good XML knowledge can explain.

RE: XML Query

abinder-1080408 — Wed, 07 Oct 2009 07:50:41 GMT

To setiv:If you want everything you need to set the "Results To Text" option. It's under Tools/Options/Query Results/SQL Server or better yet, if you have the right toolbar showing you can just click on the icon.

RE: XML Query

abinder-1080408 — Wed, 07 Oct 2009 07:44:46 GMT

"None of them" was not a choice so I picked all of them since they all return the same result.

RE: XML Query

lucky-80472 — Wed, 07 Oct 2009 07:31:41 GMT

I'm getting the same result for all the 4 queries posted.anybody else?

RE: XML Query

setiv — Wed, 07 Oct 2009 05:45:01 GMT

SELECT id as 'data()',customer as 'data()'FROM #customers AS customesraORDER BY customer DESCFOR XML PATH(''),ROOT('customers') I cannot view the full XML string.

XML Query

diego.perdices — Tue, 06 Oct 2009 23:51:53 GMT

Comments posted to this topic are about the item [B]XML Query[/B]