2024-10-14
529 reads
2024-10-14
529 reads
Get an introduction to many of the many ways you can manipulate and interact with strings using SQL. Read on for more!
2019-12-18
A nasty fast way to remove non-numeric and non-alphanumeric characters from a string
2019-03-15 (first published: 2016-05-17)
3,184 reads
Relational database management systems such as Oracle, Postgres, DB2 and Teradata, as well as other programming languages such as Python, Hive, XSLT and SAS have a Translate function. Now we have one for SQL Server.
2016-06-01 (first published: 2016-05-12)
1,054 reads
They run, they return data. So what? Some SQL queries just waste your time...
By Steve Jones
I read Brent’s first look at SSMS and Copilot in there. He didn’t have...
By Steve Jones
falesia– n. the disquieting awareness that someone’s importance to you and your importance to...
Hi Everyone I have used CASE many times but not sure what I am...
I want to calculate the end of the previous month as a date that I can use in running a report. What is the best way to do this in SQL Server 2022, assuming I have a date stored in @d?
See possible answers