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)
3,980 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
2 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
21 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,447 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
6 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
8 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
8 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
4 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
934 reads
Blogs
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Forums
Why the following cmds in sequence do not work
I need to delete rows from both the temporal main and history tables. The...
When SQL Server Central Went Down
Comments posted to this topic are about the item When SQL Server Central Went...
The String Distance I
Comments posted to this topic are about the item The String Distance I
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers