/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 vote121 views2 answers
How to install psql in ubuntu
SQL
1 vote120 views1 answer
Mysql get character set
SQL
0 vote122 views1 answer
Can we rollback data that are deleted using DELETE
SQL
0 vote110 views1 answer
Mysql select where text contains
SQL
9 votes119 views2 answers
Get first 3 letters in sql
SQL
9 votes110 views2 answers
Default number in sql
SQL
4 votes127 views1 answer
Mysql not equal
SQL
0 vote77 views1 answer
Copy table dbeaver
SQL
0 vote114 views1 answer
Postgresql array to rows
SQL
0 vote111 views1 answer
Mysql where in keep order
SQL