/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

0 vote316 views1 answer
Left join in codeigniter query builder
SQL
0 vote320 views1 answer
Update sqlaclehmy sqlalchemy.orm.evaluator.UnevaluatableError: Cannot evaluate BinaryExpression with operator <function like_op at 0x03CF1DF0>
SQL
1 vote326 views1 answer
How to between in sql
SQL
0 vote320 views1 answer
Get yesterday date ISO in psql
SQL
0 vote343 views1 answer
Store case result sql
SQL
0 vote340 views1 answer
Typeorm raw sql
SQL
5 votes334 views1 answer
How to get all dates in a month in oracle
SQL
0 vote349 views1 answer
Mysql 3 months ago
SQL
2 votes320 views2 answers
Mysql show table column comments sql
SQL
0 vote286 views3 answers
Mysql calculate age from date of birth
SQL