/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 vote252 views1 answer
Sql comment header
SQL
0 vote258 views1 answer
How to populate a table in MySQL from and existing csv file
SQL
2 votes267 views1 answer
Sql server conection string
SQL
0 vote286 views1 answer
Mysqli last row
SQL
8 votes286 views1 answer
Oracle create datafile
SQL
1 vote282 views1 answer
How to see which columns are indexxed mysql
SQL
1 vote229 views1 answer
Restart identity postgresql
SQL
1 vote275 views1 answer
What is int in mysql
SQL
6 votes226 views2 answers
Generate c# class from sql server table
SQL
0 vote290 views1 answer
SQL Server date literal
SQL