XML Workshop 26 – SELECT * FROM XML

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 Jacob Sebastian » XML Workshop 26 – SELECT * FROM XML

26 posts, Page 1 of 3

1 2 3 »»»

XML Workshop 26 – SELECT * FROM XML

Rate Topic

Display Mode

Topic Options

Author

Message

jacob sebastian

Posted Tuesday, June 29, 2010 9:51 PM

SSC-Addicted

Group: General Forum Members
Last Login: Saturday, May 11, 2013 8:17 AM
Points: 460, Visits: 2,521

Comments posted to this topic are about the item XML Workshop 26 – SELECT * FROM XML

.

Post #945181

Pinal Dave

Posted Wednesday, June 30, 2010 12:51 AM

Valued Member

Group: General Forum Members
Last Login: Saturday, May 11, 2013 5:18 AM
Points: 60, Visits: 264

Great Article. I really enjoy reading this.

Many thanks for thinking 'SELECT *'. I agree that Select * now means bring me everything.

Kind Regards,

Kindest Regards,

Pinal Dave
sqlauthority.com

Post #945234

gfabbri

Posted Wednesday, June 30, 2010 1:23 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, September 27, 2012 6:40 AM
Points: 7, Visits: 32

what about querying attributes?

Post #945248

jacob sebastian

Posted Wednesday, June 30, 2010 1:55 AM

SSC-Addicted

Group: General Forum Members
Last Login: Saturday, May 11, 2013 8:17 AM
Points: 460, Visits: 2,521

Yes, you can also query attributes.

.

Post #945267

gfabbri

Posted Wednesday, June 30, 2010 2:14 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, September 27, 2012 6:40 AM
Points: 7, Visits: 32

can you show an example of querying attributes please?
thanks in advance

Post #945284

jacob sebastian

Posted Wednesday, June 30, 2010 3:01 AM

SSC-Addicted

Group: General Forum Members
Last Login: Saturday, May 11, 2013 8:17 AM
Points: 460, Visits: 2,521

Here is a simple example:

DECLARE @xml XML
SELECT @xml = '<employee name="jacob"/>'
SELECT * FROM XMLTable(@xml)
WHERE NodeType = 'attribute'

Post #945311

dr.morgan

Posted Wednesday, June 30, 2010 3:18 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, September 29, 2011 8:53 AM
Points: 1, Visits: 21

Thank you! very useful!

Post #945316

Rhodri Evans

Posted Wednesday, June 30, 2010 3:25 AM

Grasshopper

Group: General Forum Members
Last Login: Thursday, May 09, 2013 3:51 AM
Points: 17, Visits: 113

Excellent - I can see this being very useful.

There's a couple of typos in the function definition if your server happens to be case sensitive.

Line 087 p.position should be p.Position
Line 166 XmlData should be XMLData

Post #945318

jacob sebastian

Posted Wednesday, June 30, 2010 3:35 AM

SSC-Addicted

Group: General Forum Members
Last Login: Saturday, May 11, 2013 8:17 AM
Points: 460, Visits: 2,521

Thanks, Fixed both places.

.

Post #945321

Rhodri Evans

Posted Wednesday, June 30, 2010 4:06 AM

Grasshopper

Group: General Forum Members
Last Login: Thursday, May 09, 2013 3:51 AM
Points: 17, Visits: 113

Fast work - thanks!

Post #945332

« Prev Topic | Next Topic »

26 posts, Page 1 of 3

1 2 3 »»»

Permissions