PASS Update #35
It’s been a busy month for me for PASS activities. I spent almost the entire week last week on PASS...
2010-06-28
704 reads
It’s been a busy month for me for PASS activities. I spent almost the entire week last week on PASS...
2010-06-28
704 reads
If you’re a blogger or a twitterer or a SQL speaker or PASS volunteer, you do it because you have...
2010-06-25
560 reads
Today we’ll try to finish up by looking at a couple of the semi-interesting parts of the code in this...
2010-06-24
644 reads
I’ve been experimenting with stories in the editorial, experiences of my own that are amusing and have some kind of...
2010-06-24
935 reads
Nominations opened today and will run through July 21st. Whether you’re planning to be a candidate or not, I hope...
2010-06-24
553 reads
Today we move over to the web side of things. I put this together with VS 2010, and it’s a...
2010-06-23
578 reads
Life in the event leader fast lane, finally got the signs for our upcoming #49 here in Orlando. In past...
2010-06-23
544 reads
We’re almost at the end of the SQL side of things, just needing to send out notifications/reminders. I was torn...
2010-06-22
540 reads
Actually came out last week and I missed it, here is the link to the details of the nominating committee...
2010-06-21
650 reads
Another “didn’t know” for me, we have multiple feeds from PASS HQ that focus on various areas – grab the entire...
2010-06-21
666 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