XML node value in TSQL
Better way of getting text from XML node in SQL Server
For years I've used the a simple .
to get the text value from an XML node in SQL Server (in this case converting to integer)...
SELECT X.value('.','int')
FROM @XML.nodes('/data/id') AS X(X)
However, I've recently been informed that it's much better performance to use text()[1]
instead...
SELECT X.value('text()[1]','int')
FROM @XML.nodes('/data/id') AS X(X)
Added 16/05/2022 11:31