Xml insert into sql server

Question

I am trying to insert without using bulk into SQL Server 2012. can i insert .xml file into table and i do not use bulk statement please help dhiraj

Dhiraj walunjkar · Answer

Sir My task is take .Xml File from Specific path And every time After execute stored procedure that time append data in table

Laxmidhar Sahoo · Answer

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 labor Warranty > Maintenance > 3 year parts and labor extended maintenance is available Maintenance > 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