How to count occurrences of a node in SQL XML?

sql xml sql-server-2008

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')

sql xml sql-server-2008

select @MyXML.value('count(/SampleXML/Colors)', 'INT') AS 'Count'

CodeHunter