XML Query

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by diego.perdices » XML Query

16 posts, Page 2 of 2

««1 2

XML Query

Rate Topic

Display Mode

Topic Options

Author

Message

KevinC.

Posted Wednesday, October 07, 2009 11:25 AM

Right there with Babe

Group: General Forum Members
Last Login: Tuesday, December 07, 2010 12:55 AM
Points: 771, Visits: 504

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.

Post #799386

setiv

Posted Wednesday, October 07, 2009 12:31 PM

Valued Member

Group: General Forum Members
Last Login: Tuesday, July 24, 2012 11:01 AM
Points: 50, Visits: 246

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?

Post #799421

Damian Widera-396333

Posted Friday, October 09, 2009 1:08 AM

Old Hand

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 5:46 AM
Points: 384, Visits: 186

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

Kindest Regards,

Damian Widera
SQL Server MVP,
MCT, MCITP-DBA, MCSD.NET

Post #800540

Stefano Bozzoni

Posted Tuesday, October 13, 2009 1:54 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, July 04, 2012 7:10 AM
Points: 9, Visits: 14

Quiz doesn't work at all booooh!!

Post #802001

Muhammed Rafiq

Posted Thursday, October 29, 2009 1:34 AM

Right there with Babe

Group: General Forum Members
Last Login: Monday, June 21, 2010 12:30 AM
Points: 798, Visits: 87

Me too get same result for all 4 options

Post #810543

L' Eomot Inversé

Posted Saturday, March 20, 2010 11:29 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 11:14 AM
Points: 7,087, Visits: 7,141

! I answered "which of the queries posted below ;doesn't; return..." Wink

.

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?

Tom
Que conclure à la fin de tous mes longs propos? C'est que les préjugés sont la raison des sots. (Voltaire, 1756)

Post #886936

« Prev Topic | Next Topic »

16 posts, Page 2 of 2

««1 2

Permissions