Activity overview
Latest activity by JBSandhills
Hi Aaron,
It would be nice to have the space removed because it looks a bit strange; however, it's not the end of the world if this feature has to come sometime later. As long as the NODES issue is fixed by stable release, my coworkers and I will be very happy. / comments
Hi Aaron,
It would be nice to have the space removed because it looks a bit strange; however, it's not the end of the world if this feature has to come sometime later. As long as the NODES issue is...
When formatting SQL XML statement like the following with the XML method "nodes" on my computer, nodes becomes capitalized, and this capitalization causes the query to fail. Also, I noticed that formatting puts a space between the "T" and "(x)". I don't remember that happening in previous versions. It should be:
SELECT T.x.value('./@Value1', 'INT'), T.x.value('./@Value2', 'INT')
FROM @XMLVariable.nodes('RawData/RawDataRecord') AS T(x)
After formatting:
SELECT T.x.value('./@Value1', 'INT'), T.x.value('./@Value2', 'INT')
FROM @XMLVariable.NODES('RawData/RawDataRecord') AS T (x)
I never had problems with the node keyword or its alias before the beta, so I think it might be a bug. Can you please have someone look into it?
Thanks. / comments
When formatting SQL XML statement like the following with the XML method "nodes" on my computer, nodes becomes capitalized, and this capitalization causes the query to fail. Also, I noticed that fo...