/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 vote91 views1 answer
Mssql string length
SQL
1 vote150 views1 answer
Sql how to replace full stop
SQL
0 vote133 views1 answer
Backup a table in sql
SQL
0 vote197 views1 answer
Tsql find procedure with name
SQL
3 votes171 views2 answers
Find string in stored procedure sql server
SQL
0 vote195 views1 answer
Postgres dump sql insert
SQL
0 vote138 views1 answer
Mysql return column names when table is empty
SQL
6 votes148 views1 answer
T-sql test if table exists
SQL
0 vote150 views1 answer
Enable sql server full text indexing
SQL
1 vote466 views1 answer
Mysql event last execution
SQL