The Vacation Backlash
Maybe I need a better name for it, but I’m describing the pain that happens when you’re getting ready for...
2010-07-26
590 reads
Maybe I need a better name for it, but I’m describing the pain that happens when you’re getting ready for...
2010-07-26
590 reads
Victorious by Jack Campbell ($8 at Amazon) is the finale in the six part series about Black Jack Geary leading...
2010-07-23
684 reads
Kendal posted the announcement yesterday that we opened the design content on 99designs. I’ve used the site before and it’s...
2010-07-23
573 reads
Over the past couple years our local library system has been under financial pressure, resulting in some changes, and maybe...
2010-07-22
989 reads
Today we have a guest editorial from Andy Warren. You can get more productive, but are you being productive at the tasks that you should be working on? See what Andy Warren has to say.
2010-07-21
257 reads
A bit of a silly title, but an interesting story. A few weeks back I posted a note about attending...
2010-07-21
605 reads
I saw this post (please do read it) about introducing speakers and it reminded me that I wanted to write...
2010-07-20
551 reads
We’ve had a few people in the SQL community find jobs lately and many of them attributable to their network....
2010-07-19
520 reads
I recently read Rework by Jason Fried of 37 Signals ($13 @ Amazon) and it talks about a lot of philosophy...
2010-07-16
542 reads
You can still submit abstracts through midnight tonight for SQLSaturday #49 in Orlando on October 16, 2010. Great time of...
2010-07-16
882 reads
By Steve Jones
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...
By gbargsley
One of the first things I review when I inherit a new SQL Server...
By Arun Sirpal
It’s 07:43. Someone’s already left a message. “Something’s wrong with the DB server.” You...
I have an issue where I have a Bill of Material list of items...
Comments posted to this topic are about the item Follow Your Hunch
Comments posted to this topic are about the item What Happens When You Ask...
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 TaylorHow many rows are returned? See possible answers