Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- UPDATE [amb].[Outputs]
- SET
- [XmlData] =
- '<?xml version="1.0" encoding="utf-16"?>
- <DashboardXml xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
- <Xml>' + REPLACE(REPLACE([XmlData],'<','<'), '>', '>') +'</Xml>
- <AlternativeColumns />
- <Events />
- <Filters />
- <ModelSources />
- </DashboardXml>'
- WHERE TYPE = 1 AND XmlData NOT LIKE '%<DashboardXml xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">%'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement