Skip to content

Instantly share code, notes, and snippets.

@mikerodionov

mikerodionov/Select_SI_XML.sql

Last active December 8, 2018 22:06
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/c7ce5e43a33c84341e43ff4b4031eb69 to your computer and use it in GitHub Desktop.
Save mikerodionov/c7ce5e43a33c84341e43ff4b4031eb69 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Select_SI_XML.sql
USE K2
DECLARE @SI_NAME varchar(128)
--Specify you Service Instance Display Name below
SET @SI_NAME='Oracle%'
SELECT ServiceTypeXML
FROM [K2].[SmartBroker].[ServiceType]
WHERE ServiceTypeXML.value('(servicetype/metadata/display/displayname)[1]', 'varchar(max)')
LIKE @SI_NAME;
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment