How to execute xmlnamespace in storedprocedure in SQL Server

stellusm...

SOLVED CLOSED ACTIVE ANSWERED
User: stellusmca
Posted: on Jul 11, 2016 02:49 AM
Forum: SQL Server
Answer: 1
Views: 3020

Hi all, i have tried to execute xmlnamespace in the below storedprocedure, but its saying that , Incorrect syntax near 'XMLNAMESPACES'.

My code is :

INSERT #BrandData
WITH XMLNAMESPACES('http://mch.com/IF002/SD/mch/I_mch' as ns0)
SELECT	
	Data.value('(nickname/text())[1]','VARCHAR(100)') AS nickname,
	Data.value('(username/text())[1]','VARCHAR(100)') AS username,
	Data.value('(IsActive/text())[1]','VARCHAR(4)') AS IsActive		
FROM     
	@xmldoc.nodes('//ns0:mch_In/Data')AS BrandData (Data)

please drop me a solution for this

Download FREE API for Word, Excel and PDF in ASP.Net

Shashika...

0 2

Reply
ANSWER
User: Shashikant
Replied: on Jul 11, 2016 02:54 AM
Report

Hi,

Please try below code

SQL

DECLARE @xmldoc XML

CREATE TABLE #BrandData(nickname VARCHAR(50),username VARCHAR(50),IsActive VARCHAR(4))


;WITH XMLNAMESPACES('http://mch.com/IF002/SD/mch/I_mch' as ns0)
INSERT #BrandData
SELECT 
        Data.value('(nickname/text())[1]','VARCHAR(100)') AS nickname,
        Data.value('(username/text())[1]','VARCHAR(100)') AS username,
        Data.value('(IsActive/text())[1]','VARCHAR(4)') AS IsActive
                 
FROM    
        @xmldoc.nodes('//ns0:mch_In/Data')AS BrandData (Data)

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

How to execute xmlnamespace in storedprocedure in SQL Server

Company

Explore

Follow us

Contact Us