0

Please login or register to vote for this query.

(click on this box to dismiss)

Bonjour

Q&A for professional and enthusiast programmers

declare @index int = 1
declare @xml xml = '        <cities>
            <city name="Sydney" />
            <city name="Canberra" />
            <city name="Melbourne" />
        </cities>    '

 SELECT @xml.value('count(/./*)', 'int') AS total

fork query

edited apr 9 20

created jan 29 20 anonymous