Skip to content

Instantly share code, notes, and snippets.

@mikerodionov

mikerodionov/Select_ST_XML_with_specific_path.sql

Created December 8, 2018 22:02
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/54cb3df8878f120f819d9fda010e5274 to your computer and use it in GitHub Desktop.
Save mikerodionov/54cb3df8878f120f819d9fda010e5274 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Select_ST_XML_with_specific_path.sql
SELECT *
FROM [K2].[SmartBroker].[ServiceType]
WHERE ServiceTypeXML.value('(servicetype/config/assembly/@path)[1]', 'varchar(max)')
LIKE 'D:\%';
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment