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