Read XML File in SQL Server

Example of XML Node Attribute :

Example of XML Node :

Example of XML Node using SQL query :

DECLARE @X xml

SELECT @X ='<Members>

            <Member Id="010619" Name="Arka Gupta" Email="arkaa4@gmail.com">

            </Member>

            <Member Id="010276" Name="Ram Chandra" Email="rc@gmail.com">   

            </Member>

            <Member Id="010630" Name="Laxman Kumar" Email="lk@gmail.com">

            </Member>

            <Member Id="010273" Name="Sundar Raman" Email="sr@gmail.com">

            </Member>

           </Members>'

SELECT      Members.Member.value('@Id','VARCHAR(20)')  AS 'ID',

            Members.Member.value('@Name','VARCHAR(100)') AS 'Name',

            Members.Member.value('@Email','VARCHAR(100)') AS 'Email'

FROM @X.nodes('/Members/Member') AS Members(Member)

If  there is any other better option,

Please share it here or mail to me arkaa4@gmail.com

Thank You,
Arka Gupta.

http://arkaguptablog.blogspot.in/

https://plus.google.com/+ArkaGupta-arkagupta/posts

https://in.linkedin.com/in/arkagupta