DevExpress and a Stumper
Late last year I used the DevExpress controls for a small task after they were recommended by a friend. Very...
2010-01-14
592 reads
Late last year I used the DevExpress controls for a small task after they were recommended by a friend. Very...
2010-01-14
592 reads
I bought a Bamboo Touch over the holiday break, it’s a multi-touch pad with stylus. Easy install, basically plug in...
2010-01-13
896 reads
Last week I posted about Picking a Blog Platform on some of the process that lead to me moving to...
2010-01-12
745 reads
Not sure if it went to the entire PASS mailing list or just those that have attended a Summit, but...
2010-01-12
667 reads
Posting goals online is great as long as you meet your goals, can be something less than great if you...
2010-01-12
800 reads
One of my big projects this year is to build a speaker bureau, so in this post I’m going to...
2010-01-11
754 reads
The Billion Dollar Game: Behind the Scenes of the Greatest Day In American Sport – Super Bowl Sunday
Another from the new...
2010-01-08
628 reads
One of our goals for oPASS in 2010 is to host 12 meetings instead of our usual 6. That doubles...
2010-01-08
372 reads
Brian Knight and the JSSUG team will be doing their third SQLSaturday this year on May 8, 2010, at the...
2010-01-08
318 reads
I’ll be heading to Tampa the afternoon of the 22nd for the speaker party, and then presenting Social and Not...
2010-01-07
325 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