Test Driving a LinkedIn Poll
Had this on my list for a while, thinking maybe it’s a way to leverage the investment in my (your)...
2010-04-07
258 reads
Had this on my list for a while, thinking maybe it’s a way to leverage the investment in my (your)...
2010-04-07
258 reads
We’ve been busy on the transition and we’re finally at a place where we can give you an update on...
2010-04-06
360 reads
I’ve been blogging for a couple of years now and have slowly settled into the style and pattern of blogging...
2010-04-06
302 reads
Fences is a free utility for the Windows desktop that lets you drag shortcuts into boxes you define (fences) and...
2010-04-05
432 reads
It had been a long while since I listened to an audio book, found it while browsing at the library....
2010-04-02
376 reads
I bet most of you use some type of diff/comparison tool at work. Probably one for the file system and...
2010-04-01
541 reads
Continuing on from Part 2, I want to continue this time with two points I left open last time:
How to...
2010-03-31
1,669 reads
I’ve long admired the value that I get from Wikipedia and like the concept of crowd sourcing knowledge, just never...
2010-03-30
1,649 reads
Instructables has a Paracord contest going that requires some portion of a project include paracord (often referred to as 550...
2010-03-30
1,856 reads
I arrived about 7:15 and already quite a few people on hand. Registration was moved to inside this time, just...
2010-03-29
972 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