Advertisement
Guest User

Untitled

a guest
Oct 23rd, 2017
53
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.52 KB | None | 0 0
  1. UPDATE [amb].[Outputs]
  2.    SET
  3.       [XmlData] =
  4. '<?xml version="1.0" encoding="utf-16"?>
  5. <DashboardXml xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  6.  <Xml>' + REPLACE(REPLACE([XmlData],'<','&lt;'), '>', '&gt;') +'</Xml>
  7.  <AlternativeColumns />
  8.  <Events />
  9.  <Filters />
  10.  <ModelSources />
  11. </DashboardXml>'
  12.  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