I’ve a table with one XML data type column.
XML format as below
Table: RootTable
+----+------------------------------------------------------+
|Id | Data |
+----+------------------------------------------------------+
|1 | <Root><Id>1</Id><SubRoot>Production</SubRoot></Root> |
+----+------------------------------------------------------+
|2 | <Root><Id>1</Id><SubRoot>Test</SubRoot></Root> |
+----+------------------------------------------------------+
I need to update XML as below,
+----+------------------------------------------------------+
|Id | Data |
+----+------------------------------------------------------+
|1 | <Root><Id>1</Id><SubRoot>production</SubRoot></Root> |
+----+------------------------------------------------------+
|2 | <Root><Id>1</Id><SubRoot>test</SubRoot></Root> |
+----+------------------------------------------------------+
Here I need to update the SubRoot’s value all to lower case.
Kindly help me on how to update this using T-SQL in SQL Server.
You need to sign in to view this answers
Leave feedback about this