Accessing an XML Node's Attribute

Demonstrates how to access an XML node's attribute's value. In this example, we'll access the valud for the ISBN of the first book in the following XML document, which is located at http://www.chilkatsoft.com/testData/bookstore.xml

<?xml version="1.0" standalone="yes"?>
<bookstore>
   <book ISBN="10-000000-001">
...
</bookstore>

Download Chilkat XML ActiveX

CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    DECLARE @sTmp0 nvarchar(4000)

    DECLARE @xml int
    EXEC @hr = sp_OACreate 'Chilkat.Xml', @xml OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    DECLARE @success int

    EXEC sp_OAMethod @xml, 'LoadXmlFile', @success OUT, 'bookstore.xml'
    IF @success <> 1
      BEGIN
        EXEC sp_OAGetProperty @xml, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        RETURN
      END

    --  Navigate to the 1st child (i.e. the "book" node)
    EXEC sp_OAMethod @xml, 'FirstChild2', NULL

    --  Now access the attribute:
    DECLARE @attrValue nvarchar(4000)

    EXEC sp_OAMethod @xml, 'GetAttrValue', @attrValue OUT, 'ISBN'


    PRINT @attrValue


END
GO