Top "Xml-dml" questions

How to delete an attribute from an XML variable in sql server 2008?

I have a table called XML (in SQL Server 2008) and it has a field called XmlDocument of type XML. I …

sql xml sql-server-2008 xml-dml

How to update an XML column with value from T-SQL built-in function?

I have a MS SQL 2008 R2 Standard database. I have a column with varchar(250) data and a column with xml. …

sql-server xml tsql sql-server-2008-r2 xml-dml

SQL Server XML DML Undeclared prefix

I can't understand why I get the error "XML parsing: line 2, character 45, undeclared prefix" in this simple line of code: …

sql-server xml xsd xml-dml

How to use XML.modify 'replace value' with a WHERE clause

I have an XML column that contains foreign key ID values stored within XML. I need to be able to …

xml tsql sql-server-2012 dml xml-dml

Inserting an attribute in multiple XML Nodes using XML.modify() in SQL 2005

I have an @XML document created from a single select statement. <root> <node> <node1> &…

sql-server xml sql-server-2005 xml-dml