When you write T-SQL code what kind of coding style do you use? Do you have a consistent way to comment and format your code? Does your organization provide standards for how you must code your T-SQL? Join Greg Larsen as he discusses some of the coding styles you should consider when writing your T-SQL scripts and stored procedures.
2013-04-16
6,175 reads
2013-04-15
2,227 reads
Overview of 2 very important clauses added to SELECT statement in SQL2012 to allow paging on result sets.
2013-04-10
655 reads
2013-04-08
2,155 reads
He admits it wasn't his idea but his head sure wishes it was. SQL Server MVP Jeff Moden explains a wonderful, super simple, very high performance formula that will calculate ISO Week Numbers. If you're "stuck" with SQL Server 2005 or less, you're going to like this a whole lot!
2015-10-23 (first published: 2013-04-08)
38,463 reads
2013-04-04
2,333 reads
2013-04-02
2,221 reads
The goal of this article to show how to get unique transactions per client per month from the data set containing multiple transactions per client per month.
2013-04-02
4,013 reads
Pivoting SQL Server tables is always awkward, even with the PIVOT and UNPIVOT operators. If you want to get the job done without GROUP BY or PIVOT, here is a way to do it using only REPLACE.
2013-04-01
6,173 reads
2013-03-28
2,335 reads
A while back I wrote a quick post on setting up key mappings in...
By Steve Jones
In 100 years a lot of what we take to be true now will...
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
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? See possible answers