<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by diego.perdices
»
XML Query
16 posts, Page 1 of 2
1
2
»»
XML Query
Rate Topic
Display Mode
Topic Options
Author
Message
diego.perdices
diego.perdices
Posted Tuesday, October 06, 2009 11:51 PM
Say Hey Kid
Group: General Forum Members
Last Login: Thursday, May 09, 2013 2:47 AM
Points: 705,
Visits: 239
Comments posted to this topic are about the item
XML Query
Post #798938
setiv
setiv
Posted Wednesday, October 07, 2009 5:45 AM
Valued Member
Group: General Forum Members
Last Login: Tuesday, July 24, 2012 11:01 AM
Points: 50,
Visits: 246
SELECT id as 'data()',
customer as 'data()'
FROM #customers AS customesra
ORDER BY customer DESC
FOR XML PATH(''),ROOT('customers')
I cannot view the full XML string.
Post #799083
lucky-80472
lucky-80472
Posted Wednesday, October 07, 2009 7:31 AM
Ten Centuries
Group: General Forum Members
Last Login: Wednesday, May 08, 2013 8:51 AM
Points: 1,295,
Visits: 733
I'm getting the same result for all the 4 queries posted.
anybody else?
Lucky
Post #799151
abinder-1080408
abinder-1080408
Posted Wednesday, October 07, 2009 7:44 AM
SSC Rookie
Group: General Forum Members
Last Login: Monday, November 02, 2009 7:39 AM
Points: 25,
Visits: 23
"None of them" was not a choice so I picked all of them since they all return the same result.
Post #799163
abinder-1080408
abinder-1080408
Posted Wednesday, October 07, 2009 7:50 AM
SSC Rookie
Group: General Forum Members
Last Login: Monday, November 02, 2009 7:39 AM
Points: 25,
Visits: 23
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.
Post #799169
SanjayAttray
SanjayAttray
Posted Wednesday, October 07, 2009 8:49 AM
Hall of Fame
Group: General Forum Members
Last Login: Friday, March 15, 2013 2:43 PM
Points: 3,924,
Visits: 1,554
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.
SQL DBA.
Post #799234
SanjayAttray
SanjayAttray
Posted Wednesday, October 07, 2009 8:50 AM
Hall of Fame
Group: General Forum Members
Last Login: Friday, March 15, 2013 2:43 PM
Points: 3,924,
Visits: 1,554
lucky-80472 (10/7/2009)
I'm getting the same result for all the 4 queries posted.
anybody else?
you see alias customersa and customersb in the resultset of C. where as in all other queries it's customers.
SQL DBA.
Post #799236
mtassin
mtassin
Posted Wednesday, October 07, 2009 9:48 AM
Hall of Fame
Group: General Forum Members
Last Login: Today @ 11:04 AM
Points: 3,229,
Visits: 64,266
Sanjay is right.... it got me because I wasn't reading clearly.
<customersa customers.id="6">
Is not the same as
<customers customers.id="6">
:) Good question... shows me why I hate xml as much as I do :)
--Mark Tassin
MCITP - SQL Server DBA
Proud member of the Anti-RBAR alliance.
For help with Performance click this link
For tips on how to post your problems
Post #799312
setiv
setiv
Posted Wednesday, October 07, 2009 10:02 AM
Valued Member
Group: General Forum Members
Last Login: Tuesday, July 24, 2012 11:01 AM
Points: 50,
Visits: 246
This will not help. I need to buy a new computer.
Post #799333
mtassin
mtassin
Posted Wednesday, October 07, 2009 10:52 AM
Hall of Fame
Group: General Forum Members
Last Login: Today @ 11:04 AM
Points: 3,229,
Visits: 64,266
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 :)
--Mark Tassin
MCITP - SQL Server DBA
Proud member of the Anti-RBAR alliance.
For help with Performance click this link
For tips on how to post your problems
Post #799367
« Prev Topic
|
Next Topic »
16 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
