I'm going to explain an example to find the node from an XML file using SQL Server
declare @xml-var XML;
set @xml-var =@Result;
select @CountResult=@xml-var.value('count(/courses/course)',
'INT')
In the above example,
@Result is an XML file, where we find the nodes.
@xml-var is an XML type variable.
Here XML file look like this...
<?xml version="1.01" encoding="ISO-55-4"?>
-<courses>
- <course>
<ID>1</ID>
<COURSENAME>MCA</COURSENAME>
<YEARS>2009</YEARS>
<body>Something here,,,,,,!</body>
</course>
- <course>
<ID>2</ID>
<COURSENAME>MBA</COURSENAME>
<YEARS>2011</YEARS>
<body>Something here,,,,,,!</body>
</course>
- <course>
<ID>3</ID>
<COURSENAME>B.Tech.</COURSENAME>
<YEARS>1999</YEARS>
<body>Something here,,,,,,!</body>
</course>
-</courses>
</xml>