Relative Content

Tag Archive for sqlsql-servert-sqlxpathxquery-sql

Add column name as XML node and join with other table

1.I am trying to query table column names as values of the XML Nodes and in the same node add values from the other table. I have found a code in other post that can create nodes from column names but I’m unable to add nodes from other tables.
2. My second problem is that I want to have node with the original type of the column. But I have not found anything that could help me.