/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 vote205 views1 answer
Install sql server windows 10
SQL
2 votes209 views1 answer
Oracle run_duration average
SQL
1 vote233 views1 answer
Myql find duplicates
SQL
1 vote206 views1 answer
Failed to stop mysqld.service: Unit mysqld.service not loaded.
SQL
1 vote192 views1 answer
Postgres get timestamp
SQL
0 vote234 views1 answer
Show specific events on mysql
SQL
0 vote213 views1 answer
Sqlalchemy case insensitive like
SQL
0 vote211 views2 answers
Suse stop MySQL
SQL
1 vote215 views1 answer
How to delete data from sql database in android
SQL
0 vote204 views1 answer
Renommer base sql
SQL