Xml Data fetched in sql server

DECLARE @xmlDtype NVARCHAR(200)

DECLARE @h INT

SET @xmlDtype =

'<Book>

   <Id>1</Id>

   <Author>Smith</Author>

   <Title>SQL for Beginners</Title>

</Book>'

 -- Creating XML Documents

 Exec sp_xml_preparedocument @h Output, @xmlDtype

--SELECT statement using OPENXML rowset provider

SELECT * FROM OPENXML (@h, '/Book', 2)

WITH (Id VARCHAR(20), Author NVARCHAR(20), Title NVARCHAR(20))

--------------------------------------------------------------

declare @xmldata varchar(500)

set @xmldata=

'<Book>

 <Bookdetail>

  <Id>1</Id>

  <Name>Anurag</Name>

  <City>Rayagada</City>

  </Bookdetail>

 

  <Bookdetail>

  <Id>2</Id>

  <Name>Abhi</Name>

  <City>Rayagada</City>

  </Bookdetail>

</Book>'

declare @doc int

exec sp_xml_preparedocument @doc output,@xmldata

select * from openxml(@doc,'/Book/Bookdetail',2)

with

(Id varchar(2),Name varchar(10),City varchar(20))