Parsing XML in the database

Introduction: The OpenXML method uses an example to implement the Import function

DECLARE @strProjGUID as VARCHAR (50)
DECLARE @strProjCode as VARCHAR (50)
DECLARE @idocImpXml as INT
DECLARE @xmlCount as INT
DECLARE @i as INT
DECLARE @m as INT

DECLARE @strSql as NVARCHAR (4000)

EXEC sp_xml_preparedocument @idocImpXml OUTPUT, @ImpXML---Get the document handle
--Initialize Project
SELECT @strProjGUID = projguid, @strProjCode = Projcode from OPENXML (@idocImpXml, '/impdata ')
With (projguid uniqueidentifier ' @ProjGUID ',
Projcode CHAR (+) ' @ProjCode ')

SELECT
Costguid, Costnamecode,costcode,estimatefoundation,unit
, Qty,price,hkqamount,bqftrate,amount,remarks,getmode
Into #tbImpField
From
OPENXML (@idocImpXml, '/impdata/row ', 2)
With
(
Costguid uniqueidentifier,
Costnamecode VARCHAR (40),
Costcode VARCHAR (100),
Estimatefoundation VARCHAR (100),
Unit VARCHAR (50),
Qty Money,
Price Money,
Hkqamount Money,
Bqftrate Money,
Amount Money,
Remarks VARCHAR (4000),
GetMode VARCHAR (20)
)

---close handle
EXEC sp_xml_removedocument @idocImpXml

Parsing XML in the database