Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

XML Query Expand / Collapse
Author
Message
Posted Wednesday, October 07, 2009 11:25 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight 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
Posted Wednesday, October 07, 2009 12:31 PM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued 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
Posted Friday, October 09, 2009 1:08 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Sunday, March 30, 2014 11:40 AM
Points: 459, Visits: 256
The third query gives other result than first tree - look at the element names

Kindest Regards,

Damian Widera
SQL Server MVP,
MCT, MCSE Data Platform, MCSD.NET
Post #800540
Posted Tuesday, October 13, 2009 1:54 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Thursday, October 29, 2009 1:34 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight 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
Posted Saturday, March 20, 2010 11:29 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 4:56 PM
Points: 8,271, Visits: 8,717
Oh ! I answered "which of the queries posted below ;doesn't; 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) to decipher a query with FOR XML in it.

edit: change < and > to [ and ]. Whose idea was sqare brackets for presentation markup, anyway?


Tom
Post #886936
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse