Logo Selected for SQLRally
Hopefully everyone saw the announcement already, either via the PASS Connector or the Twitter announcement, but we have – finally! – a...
2010-08-11
385 reads
Hopefully everyone saw the announcement already, either via the PASS Connector or the Twitter announcement, but we have – finally! – a...
2010-08-11
385 reads
The ‘Summit Preview’ edition, this time around it features speakers from the upcoming PASS Summit with each doing a one...
2010-08-11
341 reads
Consider this one a thinking out loud post more than most. We’ve had an explosion of speakers in the SQL...
2010-08-10
229 reads
MS just announced this publicly last week, it’s a Visual Studio product that seems to be geared towards the not-quite-developer...
2010-08-10
355 reads
Kendal Van Dyke blogged about it last week here, we ended up with 3 great designs to pick from for...
2010-08-09
333 reads
One of the things I think we don’t do well sometimes – in generally – is set fair expectations with regards to...
2010-08-09
658 reads
Over the course of my life I’ve lived in a few different places; small home, apartment, pup tent, large tent,...
2010-08-06
535 reads
Being a good mentor is hard, perhaps harder than being a parent, because with children it’s fair to share with...
2010-08-05
390 reads
In addition to being at at #40 as an attendee, I also had Don Gabor there to take a look...
2010-08-04
335 reads
Had a reasonably uneventful four drive to Miramar Friday, arriving in time to check in at the hotel and then...
2010-08-03
526 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