Returning multiple rows from XML

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Programming » XML » Returning multiple rows from XML

12 posts, Page 2 of 2

««1 2

Returning multiple rows from XML

Rate Topic

Display Mode

Topic Options

Author

Message

grovelli-262555

Posted Friday, November 02, 2012 9:12 AM

SSC Journeyman

Group: General Forum Members
Last Login: Today @ 5:24 AM
Points: 84, Visits: 684

Are there any books that explain syntax such as $x or //EXPR
?

Post #1380437

arthurolcot

Posted Tuesday, November 06, 2012 11:19 AM

SSCommitted

Group: General Forum Members
Last Login: Yesterday @ 1:50 AM
Points: 1,726, Visits: 1,413

grovelli-262555 (11/2/2012)

Are there any books that explain syntax such as $x or //EXPR
?

Hi grovelli,
$x is a variable within a flwor statement. You can begin to learn about flwor statements here: http://msdn.microsoft.com/en-us/library/ms190945.aspx

//EXPR is a path expression. A starting point again would be BOL here: http://msdn.microsoft.com/en-us/library/ms189919.aspx

With regard to a book regarding XML itself, there are a good couple of good SQL books pretty much dedicated to the XML data type and how to work with it e.g. XQuery, XML DML etc. I don't have a particular one to recommend as it depends on exactly what you want to learn, but the ones by Wrox or Apress are probably good starting points if you want to learn more about SQL XML.

Post #1381669

« Prev Topic | Next Topic »

12 posts, Page 2 of 2

««1 2

Permissions