I’m Attending the South Florida Code Camp on February 27, 2010
I’m driving down tomorrow for the sixth annual South Florida Code Camp. This will be my third time attending and...
2010-02-25
524 reads
I’m driving down tomorrow for the sixth annual South Florida Code Camp. This will be my third time attending and...
2010-02-25
524 reads
If you’ve been around SQL for any length of time it’s hard not to have heard of Brad McGehee, the...
2010-02-24
566 reads
I’m in the early stages of a book on managing and I’m starting to look for situations that might trigger...
2010-02-23
1,100 reads
This happened earlier in the year, finally getting around to writing some notes on it – you can read more here....
2010-02-22
733 reads
Ran across this in Make Magazine, http://www.bigkidbike.com/, these are totally custom bikes, with names like Bigger Wheel, Lizard, and Kitten....
2010-02-19
551 reads
I’m in Chicago for a couple days next week, flying in on Sunday. Anyone in the area available for dinner...
2010-02-18
541 reads
Joe Healy is doing a four hour Azure training event on March 6, 2010 in Orlando, details and free registration...
2010-02-18
665 reads
My friend Jack posted a nice aggregate of comments so far about the transfer of SQLSaturday to PASS, and added...
2010-02-18
550 reads
Found The Adversity Index while browsing and thought I’d share. It’s interesting to see the economic trends and I’ll let...
2010-02-18
501 reads
Today we have a guest editorial from Andy Warren. Balancing work and life is a challenge, and today Andy looks at one way that has helped him to manage his hours and learn to get away from work.
2010-02-18
117 reads
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...
By gbargsley
One of the first things I review when I inherit a new SQL Server...
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