/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 vote294 views1 answer
Snowflake rename column name
SQL
-1 vote285 views1 answer
What is in operator
SQL
0 vote266 views1 answer
Mysql events not work
SQL
0 vote307 views3 answers
Drop table operation failed on table 'TableHistory' because it is not supported operation on system-versioned temporal tables.
SQL
0 vote315 views1 answer
Add week ending date sql server
SQL
0 vote313 views1 answer
Mysql record group by created date count
SQL
0 vote277 views1 answer
Sql remove first character from string
SQL
0 vote290 views2 answers
How to generate a unique random number in mysql
SQL
0 vote283 views1 answer
What is default mysql database password in linux
SQL
0 vote297 views1 answer
Basic structure of sql expression having clause
SQL