Viewing 2 posts - 1 through 2 (of 2 total)
Dear Brian Gale,
The OP just needs to migrate off the current SQL Server 2008R2 to a newer version.
Starting from SQL Server 2012, it has a very powerful new index: Selective...
May 12, 2021 at 6:11 pm
#3882449
XML is case sensitive by definition. There is no escape from it.
Two points to mention.
(1) You can try the following approach by using a different XPath predicate like below.
(2) Additionally,...
May 11, 2021 at 7:08 pm
#3882042