Click here to monitor SSC
SQLServerCentral is supported by Redgate
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: Thursday, April 14, 2016 3:45 AM
Points: 108, Visits: 868
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: 2 days ago @ 7:52 AM
Points: 2,922, Visits: 1,770
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