Convert int IP-address to dot-notation

integer IP-address converted to varchar dot-notationUsage SELECT dbo.IPNumberToString(-2037012288)

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2004-10-20 (first published: 2004-07-29)

438 reads

Setting permissions (fix for no dbo users)

fix script from tcartwright@thesystemshop.com (http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=600) for no dbo users

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2002-12-02

157 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?