SQLSaturday #21 Event Update
Thought I’d share some of the event for those you not in the Orlando area. As of today we have...
2009-08-27
522 reads
Thought I’d share some of the event for those you not in the Orlando area. As of today we have...
2009-08-27
522 reads
The call for nominations for the PASS Board of Directors is open until Sep 3rd and I want to reiterate...
2009-08-26
1,282 reads
I enjoy woodworking as a hobby and as I try new things I find that my work habits during the...
2009-08-26
1,571 reads
I’ve been reading his blog for a while and getting consistently good value. I’d categorize it as a SQL blog...
2009-08-25
719 reads
Last but certainly not least we’ve just announced Kalen Delaney as a member of the Advisory Council. Now that we...
2009-08-25
573 reads
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-08-25
537 reads
It’s been a busy few weeks since update #12. We announced guidelines for submitting content to sqlpass.org, an effort that...
2009-08-23
738 reads
I’ve touched on it some in the past, but it’s a question that comes up a lot when we discuss...
2009-08-21
2,360 reads
You’ve probably heard of Costco, one of those warehouse type stores that sells stuff in bulk. We buy stuff there...
2009-08-20
572 reads
Just announced at http://blog.sqlsaturday.com/2009/08/sqlsaturday-advisory-council-newest.html, Buck makes three – one more to go coming up soon!
2009-08-19
547 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