Tame Those Strings! Part 2 - Using CHARINDEX
The second part of Steve Jones's series on programming and manipulating strings in T-SQL.
The second part of Steve Jones's series on programming and manipulating strings in T-SQL.
The third part of Steve Jones's series on programming and manipulating strings in T-SQL dealing with REPLACE.
This is another part in my series designed to offer guidance around common issues in SQL Server. Today, let’s talk about the all-too-common error: invalid length.
The fourth part of Steve Jones's series on programming and manipulating strings in T-SQL dealing with numeric conversions.
The fifth part of Steve Jones's series on programming and manipulating strings in T-SQL dealing with STUFF.
Need to proper case names? Want a quick way to reformat a series of words? This article examines a SQL approach to quickly proper casing all words in a field.
This article shows how you can deploy SQL Server Developer Edition in an AWS Kubernetes configuration.
This is a list of the builds for SQL Server 2022. There are other build lists available here. A list of all the builds that I can find and install on my Build VM. If you find a build not listed here, please let the webmaster know (webmaster at sqlservercentral.com). All builds are listed in reverse […]
This is a list of the builds for SQL Server 2025. There are other build lists available here. A list of all the builds that I can find and install on my Build VM. If you find a build not listed here, please let the webmaster know (webmaster at sqlservercentral.com). All builds are listed in reverse […]
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Comments posted to this topic are about the item The Power of Data and...
Comments posted to this topic are about the item What's the Date?
Comments posted to this topic are about the item Two New Shortcuts for Fabric...
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers