Diogo Castro

Representing XML data in SQL Server

In this article, we will see how to use the FOR XML statement in SQL Server to represent the result of queries in XML format.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(21)

You rated this post out of 5. Change rating

2020-04-24 (first published: 2018-08-07)

6,692 reads

A while back I wrote a quick post on setting up key mappings in...

In 100 years a lot of what we take to be true now will...

hi , i hear more and more that we have too many connections to...

Hi, i'm running vs2022. I'm trying out a c# script that i'd like to...

Comments posted to this topic are about the item Missing the Jaro Winkler Distance

I upgraded a SQL Server 2019 instance to SQL Server 2025. I wanted to test the fuzzy string search functions. I run this code:

SELECT JARO_WINKLER_DISTANCE('tim', 'tom')

I get this error message:

Msg 195, Level 15, State 10, Line 1 'JARO_WINKLER_DISTANCE' is not a recognized built-in function name.

What is wrong?