Hi...
Try this link.
http://www.codeproject.com/KB/database/DataTableAsXMLToDataBase.aspx[
^]
And also check this
ALTER PROCEDURE [dbo].[InsertShortTermPrice]
@xmlDoc varchar(MAX)
AS
declare @hDoc int
BEGIN TRANSACTION
EXEC sp_xml_PrepareDocument @hDoc OUT, @XMLDoc
INSERT INTO shortTerm_pricelist
SELECT propertyid,startdate,enddate,weeklyrate,orderseq
SELECT
x.item.value('@propertyid[1]', 'Bigint') AS propertyid,
x.item.value('@startdate[1]', 'Datetime') AS startdate,
x.item.value('@enddate[1]', 'Datetime') AS enddate,
x.item.value('@weeklyrate[1]', 'Bigint') AS weeklyrate,
x.item.value('@orderseq[1]', 'Bigint') AS orderseq
FROM @hDoc.nodes('//Record/Price') AS x(item)
COMMIT TRANSACTION