xmlnamespaces feature required in sql azure
We have started shifting our enterprise application to windows azure platform...
but we have critical issue where we are using XMLNAMESPACES in attribute level ... since sql azure is not supporting this syntax what can be the best alternative or will it be supported in future sql azure features.....
this is business based enterprise application developed based on many client requirements we cannot change the xml format.. so please provide xmlnamespaces features in sql azure
DECLARE @x xml ,
@L_C VARCHAR(10),
@l_cnt numeric(10),
@doc int
BEGIN
SET @x='<F CT:I="54" CT:Ins="" CT:F="1" CT:X="F$F$" xmlns:CT="your:namespace" DEF="1">
</F>'
;WITH XMLNAMESPACES ('your:namespace' as "CT")
SELECT c.value('@CT:I','NUMERIC(10)') AS CT_I,
c.value('@C','NUMERIC(10)') AS C FROM @x.nodes('//F') AS T(c)
END
Syed Amrullah Mazhar
shared this idea
1 comment
-
Amreen
commented
Yes, I too go with you syed, we require xmlNamespaces at attribute level, since most of the time we use xml,
It would be really helpful if XML Namespaces features at attribute level are included in SQL Azure
