/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 vote363 views1 answer
Function plsql
SQL
1 vote346 views1 answer
Sql get all columns from one table but one from another inner join
SQL
5 votes358 views1 answer
How to check nls format in oracle
SQL
0 vote377 views1 answer
Sql menampilkan data tabel
SQL
0 vote380 views1 answer
How to print some string in mysql
SQL
5 votes380 views2 answers
Sql server port number
SQL
0 vote373 views1 answer
Write a query to peint the pattern P(20)
SQL
3 votes404 views1 answer
How to add unique constraint in mysql table
SQL
1 vote362 views1 answer
Postgresql blocked on mac
SQL
51 votes749 views6 answers
Installing mysql on ubuntu
SQL