When a query is edited in the XQuery editor, the XPath expressions can be composed
quickly by dragging them from the Data Source Explorer view and
dropping them into the editor panel.
-
Configure the data source to the relational database.
-
Configure the connection to the relational database.
-
Browse the connection in the Data Source Explorer view, expanded
to the table or column that you want to insert in the query.
-
Drag the table or column name to the XQuery editor panel.
-
Drop the table or column name where the XPath expression is needed.
An XPath expression that selects the dragged name is inserted in the XQuery document at
the cursor position.