/SQL/SQL SERVER xquery count child nodes

SQL SERVER xquery count child nodes

This will count the number of Colors nodes which is 1.

select @MyXML.value('count(/SampleXML/Colors)', 'int')

This will count the number of rows in Colors which is 5.

select @MyXML.value('count(/SampleXML/Colors/*)', 'int')

Source: stackoverflow.com

Similar codes

6 votes190 views2 answers
Can't connect to local mysql server through socket
SQL
2 votes202 views1 answer
Orcale index size
SQL
0 vote194 views1 answer
PSQL qith variables
SQL
0 vote200 views1 answer
Mysql docker image arjun
SQL
1 vote205 views1 answer
Top 10 rows in mysql
SQL
0 vote199 views1 answer
Example of sql querry result sepapreted by comma
SQL
0 vote184 views1 answer
Connect postgresql using a connection string
SQL
0 vote205 views1 answer
Mariadb current date plus 1 day
SQL
1 vote187 views1 answer
Is sql fast
SQL
1 vote189 views1 answer
Mysql count multiple columns in one query
SQL