/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

1 vote259 views3 answers
How to pass password to mysql command line
SQL
0 vote259 views1 answer
Python sql last insertend
SQL
7 votes244 views6 answers
Nth highest salary in sql
SQL
0 vote250 views1 answer
Postgresql auto increment not working
SQL
1 vote247 views3 answers
Union in sql
SQL
3 votes231 views3 answers
List columns in table postgres
SQL
9 votes240 views4 answers
Oracle get table column names
SQL
0 vote235 views1 answer
Mariadb used space
SQL
0 vote230 views1 answer
How to find the most occuring in SQL
SQL
0 vote245 views1 answer
Drop procedure sql
SQL