Got Any Grapes?
This past weekend we took a mini vacation, along the way my daughter decided to play this song, which is...
2013-05-14
600 reads
This past weekend we took a mini vacation, along the way my daughter decided to play this song, which is...
2013-05-14
600 reads
It’s not uncommon to get frustrated about something at work and send out an email blasting whatever person or group...
2013-05-10
706 reads
I read quite a bit and it’s rare that I don’t have a book or magazine with me in case...
2013-05-07
677 reads
Recently at work we had a “Hawaiian Shirt Day”, a nice change from the usual business casual. I picked one...
2013-05-06
585 reads
For the past couple months I’ve been looking forward to a 5 week break, a chance to think about what...
2013-04-30
1,406 reads
As I re-read the original Looking Back post I realized I didn’t include anything about the fear part – stepping away...
2013-04-29
1,254 reads
Spend a few minutes reviewing 20 Critical Security Controls. Very interesting stuff. For example, #1 refers to having and maintaining...
2013-04-27
809 reads
In July 2011 I took what felt like a big chance and a detour to lead a large and complex...
2013-04-24
731 reads
The Way, starring Martin Sheen and directed by Emilio Estevez has been on my want to watch list for a...
2013-04-23
675 reads
I’ll be attending and presenting at SQLSaturday #200 in Philadelphia in June, then I’ll be attending the first ever SQLSaturday...
2013-04-22
650 reads
By James Serra
Once again there were a number of Microsoft Build announcements related to data and...
A good week ago I hosted the monthly T-SQL Tuesday blog party. I invited...
By Steve Jones
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...
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