SQL Server REPLACE
In this article we look at the SQL Server REPLACE function and show several examples of how this can be used to replace text values in strings.
2020-12-28
system functions
SQL Server System Functions: The Basics
Every SQL Server Database programmer needs to be familiar with the System Functions. These range from the sublime (such as @@rowcount or @@identity) to the ridiculous (IsNumeric()) Robert Sheldon provides an overview of the most commonly used of them.
2016-04-18
6,053 reads
Blogs
Goal Progress for April 2021
By Steve Jones
I set goals at the beginning of the year, and I’m tracking my progress...
Daily Coping 7 May 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
A notebook, a guideline, and a workshop
By Jen McCown
I've come to the conclusion that most of us need to hear this: You...
Forums
Checking Up on Vendors
Comments posted to this topic are about the item Checking Up on Vendors, which...
Count Group By and CASE
Today I learned that Group and Count do not pay attention to "THEN" in...
Best way to automate password reset of sql account
I'm looking to have a timer job every 90 days that runs a ps...
Ask SSC