/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
Mysql range of dates overlap
SQL
0 vote188 views1 answer
Varchar2 length in oracle
SQL
0 vote175 views1 answer
Set column width in sqlplus
SQL
0 vote139 views1 answer
How to get last client id sql
SQL
0 vote199 views1 answer
How to remove quotes from a string in ssis load file
SQL
1 vote202 views1 answer
Get current date in pyspark sql
SQL
1 vote184 views2 answers
Grab part of a string sql
SQL
0 vote175 views1 answer
Alter table myisam to innodb
SQL
1 vote193 views1 answer
Postgresql round double precision
SQL
2 votes209 views2 answers
Null column to 0 in mysql
SQL