/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

3 votes178 views1 answer
How to uninstall microsoft sql server
SQL
1 vote155 views1 answer
Psql show with user is logged in
SQL
2 votes182 views3 answers
Copy data from one table column to another table column in sql
SQL
0 vote161 views1 answer
Postgresql remove duplicate rows 2 columns
SQL
0 vote167 views1 answer
How to get initials in sql
SQL
104 votes277 views2 answers
Like in mysql
SQL
4 votes194 views2 answers
Sqlalchemy_database_uri for mysql
SQL
0 vote178 views1 answer
Sql delete from with relation
SQL
0 vote172 views1 answer
How to reset table in sql server
SQL
0 vote167 views1 answer
How to select even id in sql
SQL