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

Returning multiple rows from XML Expand / Collapse
Posted Friday, November 2, 2012 9:12 AM


Group: General Forum Members
Last Login: Saturday, August 22, 2015 7:45 AM
Points: 106, Visits: 842
Are there any books that explain syntax such as $x or //EXPR
Post #1380437
Posted Tuesday, November 6, 2012 11:19 AM


Group: General Forum Members
Last Login: Wednesday, September 30, 2015 12:01 PM
Points: 2,847, Visits: 1,760
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:

//EXPR is a path expression. A starting point again would be BOL here:

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 »

Add to briefcase ««12

Permissions Expand / Collapse