Scripts

Blogs

No Shortcuts for the SQLCMD Batch Terminator: #SQLNewBlogger

By

I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...

Where Is My SQL Agent? Running Scheduled Jobs Against Azure SQL Database

By

One of the first things I review when I inherit a new SQL Server...

AgentDBA vs Critical SQL Server

By

It’s 07:43. Someone’s already left a message. “Something’s wrong with the DB server.” You...

Read the latest Blogs

Forums

ALAMAT KANTOR BCA KCU SIDOARJO TLP/WA 0817839777

By m4rt1n4

Cs: 0817839777 Jl. Ahmad Yani No.39 A, Rw1, Sidokumpul, Kec. Sidoarjo, Kabupaten Sidoarjo, Jawa...

Increment a number in a SQL Query based on a value

By bswhipp

I have an issue where I have a Bill of Material list of items...

Follow Your Hunch

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Follow Your Hunch

Visit the forum

Question of the Day

Detecting Characters

I have a SQL Server 2022 English default installation on a server. I want to detect if there are any upper case characters in rows and I have this code: 

SELECT CustomerNameID,
       CustomerName
 FROM dbo.CustomerName
 WHERE CustomerName = LOWER(CustomerName)
Here is the sample data I am testing with: 
CustomerNameID CustomerName
1              John Smith
2              Sarah Johnson
3              MICHAEL WILLIAMS
4              JENNIFER BROWN
5              david jones
6              emily davis
7              Robert Miller
8              LISA WILSON
9              christopher moore
10             Amanda Taylor
How many rows are returned?

See possible answers