Xml insert into sql server

sir the bellow code may usefull to you

USE [Test]
GO
/****** Object: StoredProcedure [dbo].[tempgetxml] Script Date: 12/21/2017 15:20:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[tempgetxml]
as
begin
DECLARE @myDoc xml
DECLARE @ProdID int
SET @myDoc = '<Root>
<ProductDescription ProductID="1" ProductName="Road Bike">
<Features>
<Warranty>1 year parts and laborWarranty>
<Maintenance>3 year parts and labor extended maintenance is availableMaintenance>
Features>
ProductDescription>
Root>'
--SET @ProdID = @myDoc.value('(/Root/ProductDescription/@ProductID)[1]', 'int' )
SET @ProdID = @myDoc.value('(/Root/ProductDescription/@ProductName)[1]', 'NVARCHAR(MAX)' )
SELECT @ProdID
end

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Dhiraj walunjkar8y ago
Sir,

My task is take ".Xml" File from Specific path And every time After execute stored procedure that time append data in table
0
Laxmidhar Sahoo8y ago
sir the bellow code may usefull to you
USE [Test]
GO
/****** Object:  StoredProcedure [dbo].[tempgetxml]    Script Date: 12/21/2017 15:20:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[tempgetxml]
as
begin
DECLARE @myDoc xml
DECLARE @ProdID int
SET @myDoc = '<Root>
<ProductDescription ProductID="1" ProductName="Road Bike">
<Features>
  <Warranty>1 year parts and laborWarranty>
  <Maintenance>3 year parts and labor extended maintenance is availableMaintenance>
Features>
ProductDescription>
Root>'

--SET @ProdID =  @myDoc.value('(/Root/ProductDescription/@ProductID)[1]', 'int' )
SET @ProdID =  @myDoc.value('(/Root/ProductDescription/@ProductName)[1]', 'NVARCHAR(MAX)' )
SELECT @ProdID

end
0