/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

2 votes308 views2 answers
Useradd postgres
SQL
0 vote307 views1 answer
Dasebase_url-postgres for windows
SQL
-1 vote312 views1 answer
Mysql change database charset and collation
SQL
2 votes302 views1 answer
Oracle sql drop table purge
SQL
0 vote294 views1 answer
Oracle index hint multiple tables example
SQL
0 vote319 views1 answer
Get who is hired in month in sql
SQL
0 vote326 views1 answer
Hotw to alter lengh character vayng postgres
SQL
10 votes312 views1 answer
Oracle all_dependencies
SQL
0 vote298 views1 answer
Myswql show full processlist
SQL
0 vote312 views1 answer
How to convert DateTime to VarChar SQL
SQL