/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 votes286 views4 answers
Sqlite drop table
SQL
0 vote307 views1 answer
Logtash mysql cofiguration file
SQL
0 vote323 views1 answer
Sql remove non numeric characters
SQL
4 votes379 views1 answer
How to check last gather stats on table in oracle
SQL
15 votes294 views3 answers
Find duplicate keys in mysql
SQL
0 vote290 views1 answer
Unique index in mysql
SQL
0 vote312 views1 answer
Selecting duplicates
SQL
2 votes297 views2 answers
Sql strip non alphanumeric characters
SQL
57 votes489 views6 answers
Sql alter table
SQL
0 vote294 views2 answers
Transaction php
SQL