Skip to content

Instantly share code, notes, and snippets.

@mikerodionov

mikerodionov/Update_ST_XML.sql

Last active December 8, 2018 22:05
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mikerodionov/7a3325b9cd66304349461c19a60e04ff to your computer and use it in GitHub Desktop.
Save mikerodionov/7a3325b9cd66304349461c19a60e04ff to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Update_ST_XML.sql
UPDATE [K2].[SmartBroker].[ServiceType]
SET ServiceTypeXML =
'
<servicetype name="SourceCode.SmartObjects.Services.Oracle.OracleService" guid="c599f60f-7640-4d64-8103-38d60b7c6b61">
<metadata>
<display>
<displayname>Oracle Service</displayname>
<description />
</display>
</metadata>
<config>
<assembly path="C:\Program Files (x86)\K2 blackpearl\ServiceBroker\SourceCode.SmartObjects.Services.Oracle.dll" class="SourceCode.SmartObjects.Services.Oracle.OracleService" />
</config>
</servicetype>
'
WHERE ServiceTypeXML.value('(servicetype/metadata/display/displayname)[1]', 'varchar(max)')
LIKE 'Oracle%';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment