SQL Server xml column

[expired user #8373]'s profile image [expired user #8373] posted 9 years ago in General Permalink

1) xml column in table definition is like 'int' or 'tinyint' with 'max' lenght, strange no ?

2) How can I edit an xml column ? I can read it, but I have an error message when updating in design mode
(I must use a query like this to change only the -Auto Level- from 2 to 1 : UPDATE Acc_Zone SET Details = N'<?xml version="1.0" encoding="utf-16"?>
<Cfg xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<Auto Id="2" Level="1" />
</Cfg>' WHERE Id = 130)

[expired user #8661]'s profile image [expired user #8661] posted 9 years ago Permalink
I have the same problem.
It is possible to fix this error in order to support data type xml? We are using MS SQL Server.
xamadev's profile image xamadev posted 2 months ago Permalink


XML columns of MS SQL Server are still not very well supported. Is it on the plan do improve this? I cannot edit the XML string or delete a row which contains an XML column.

Thanks in advance.

Please login to leave a reply, or register at first.