/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

5 votes376 views6 answers
In operator sql
SQL
0 vote358 views1 answer
Starting mysql shell lampp ubuntu
SQL
0 vote327 views1 answer
How many columns can be used for creating index?
SQL
0 vote366 views1 answer
Caused by: java.lang.RuntimeException: Unable to obtain credentials to communicate with the Cloud SQL API
SQL
1 vote507 views3 answers
Uninstall postgresql mac
SQL
3 votes349 views1 answer
Oracle revoke grant
SQL
0 vote358 views1 answer
Postgresql get diff between two dates in Months
SQL
0 vote375 views1 answer
Alter table add check constraint oracle
SQL
1 vote326 views1 answer
Can we drop a primary key
SQL
0 vote359 views1 answer
Frename oracle
SQL