You are welcome!

Pallav,

By namespace declaration, i meant the statement 'WITH XMLNAMESPACES' at the beginning of your query. Run the previous example and see if it works well on your table.

Yes, you need to add the namespace declaration. Also, make sure that you use the same expression in the value() method as given in my example.

I created an example that closely matches your requirement. See this example:

DECLARE @t TABLE (data NVARCHAR(MAX))

INSERT INTO @t (data) SELECT '

[SearchCriteriaDS xmlns="http://www.teuri.org/SearchCriteriaDS.xsd"]

[SearchCriterias d2p1:Name="abc@abc.gov-emails" d2p1:SearchTemplateID="-1" d2p1:OnlyNew="true" d2p1:SourceTargetDirection="3" d2p1:SampleSize="100" d2p1:MinimumNumberRecipient="0" d2p1:AutoAccept="false" d2p1:SampleCap="-1"...

I see that there is a namespace declared already. I did not see it earlier because it was on the far right corner.

I replaced the double quotes and the following...

You need to fix a few issues with the XML documen before you can process them.

1. You are using a namespace prefix in the attribute names. But the namespace prefix...

Hi, some how the XML does not show up in your post. Could you replace the XML tags with '[]' and see if that works?

I would suggest that you serialize the object to an XML string pass it to the stored procedure. From within your stored procedure you can extract the information from the...

Another option is (if you are on SQL server 2005) to use OBJECT_DEFINITION() function.

SELECT OBJECT_DEFINITION(OBJECT_ID('NameOfObject'))

NameofObject can be a view, stored procedure, function etc.

I suppose, what you need is a way to load the XML data to a SQL Server table. You have a few options for that. You may use a TSQL...

Does this query run on SSMS? It looks like there is something going wrong with the query and it is not returning an XML stream.

Good post!

Another option is to use a recursive CTE that returns the entire dependency chain in a single query. I wrote such a function and the code is posted here:...

Welcome 🙂

Antonio,

You might need to work with TYPED XML to achieve this. You need to create a schema collection and set the element to be "nillable". Then in your XML instance,...

sachinthamke (6/19/2008)

---

Nice Article with clear explanation

I have one query, whenever inserting records in the details table (OrderDetails), is there any limit for XML

as per my knowledge xml data...