4 Ways To Define Lookup Values In A Query
Watch this week’s episode on YouTube.
Occasionally you may need to create a lookup table of values for a single query. ...
2018-06-13 (first published: 2018-06-05)
4,008 reads
Bert Wagner
4 Ways To Define Lookup Values In A Query
Watch this week's video on YouTube
Occasionally you may need to create a lookup table of values for a single query. Building a permanent table of these values is a...
2018-06-05
3 reads
4 Ways To Define Lookup Values In A Query
Watch this week's video on YouTube
Occasionally you may need to create a lookup table of values for a single query. Building a permanent table of these values is a...
2018-06-05
22 reads
What Does The GO Command Do?
Watch this week’s episode on YouTube.
When I started working with T-SQL, I thought the GO command was optional, kind of...
2018-06-08 (first published: 2018-05-29)
3,452 reads
What Does The GO Command Do?
Watch this week's video on YouTube
When I started working with T-SQL, I thought the GO command was optional, kind of like semicolons. It appeared in plenty of SSMS generated...
2018-05-29
7 reads
What Does The GO Command Do?
Watch this week's video on YouTube
When I started working with T-SQL, I thought the GO command was optional, kind of like semicolons. It appeared in plenty of SSMS generated...
2018-05-29
9 reads
Converting JSON to SQL Server CREATE TABLE Statements
Watch this week’s episode on YouTube.
Tedious, repetitive tasks are the bane of any lazy programmer. I know, because I am...
2018-05-28 (first published: 2018-05-22)
3,796 reads
Converting JSON to SQL Server CREATE TABLE Statements
Watch this week's video on YouTube
Tedious, repetitive tasks are the bane of any lazy programmer. I know, because I am one.
One such repetitive task that I find comparable to...
2018-05-22
9 reads
Converting JSON to SQL Server CREATE TABLE Statements
Watch this week's video on YouTube
Tedious, repetitive tasks are the bane of any lazy programmer. I know, because I am one.
One such repetitive task that I find comparable to...
2018-05-22
5 reads
Why Is My VARCHAR(MAX) Variable Getting Truncated?
Watch this week’s episode on YouTube.
Sometimes SQL Server doesn’t do what you tell it to do.
Normally that’s ok – SQL is...
2018-05-15
948 reads
Blogs
RANK() vs DENSE_RANK(): #SQLNewBlogger
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Forums
Missing the Jaro Winkler Distance
Comments posted to this topic are about the item Missing the Jaro Winkler Distance
25 Years Later: What SQLServerCentral Meant to Me
Comments posted to this topic are about the item 25 Years Later: What SQLServerCentral...
Doing Good at SQL Server Central
Comments posted to this topic are about the item Doing Good at SQL Server...
Question of the Day
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? See possible answers