how can i validate xml node using xmlnamespace in storedprocedre in SQL Sqrver

stellusm...

SOLVED CLOSED ACTIVE ANSWERED
User: stellusmca
Posted: on Jul 11, 2016 04:29 AM
Forum: SQL Server
Answer: 1
Views: 3322

Hi all, how can i validate xml node using xmlnamespace in storedprocedre

i have tried it but its saying that , Incorrect syntax near the keyword 'IF'.

My code is :


ALTER PROCEDURE mch
@xmldoc  XML
AS
BEGIN

									
         ;WITH XMLNAMESPACES('http://MCH.com/IF002/SD/MCGG/MCH' as ns0)
			
			
			IF(SELECT @xmldoc.exist('//ns0:Brand_In/MC/MC1') AS BrandData)=0 BEGIN RAISERROR('MC1 not available in document',16,1); RETURN ; END 


END

Shashika...

0 1

Reply
ANSWER
User: Shashikant
Replied: on Jul 11, 2016 04:31 AM
Modified: on Jul 11, 2016 09:21 AM
Report

Please refer below code

SQL

ALTER PROCEDURE mch
    @xmldoc XML
AS
BEGIN
    DECLARE @Count INT    
    ;WITH XMLNAMESPACES('http://MCH.com/IF002/SD/MCGG/MCH' as ns0)
    SELECT @Count = 1
    FROM @xmldoc.nodes('//ns0:Brand_In/MC')AS BrandData (Data)
    WHERE @xmldoc.exist('//ns0:Brand_In/MC/MC1') = 1

    IF @Count != 1
    BEGIN 
        RAISERROR('MC1 not available in document',16,1); 
    END
END

how can i validate xml node using xmlnamespace in storedprocedre in SQL Sqrver

Company

Explore

Follow us

Contact Us