Featured Blogger: Tim Mitchell
I met Tim about a year and a half ago at SQLSaturday Jacksonville and from the start we hit it...
2009-12-02
280 reads
I met Tim about a year and a half ago at SQLSaturday Jacksonville and from the start we hit it...
2009-12-02
280 reads
Recently announced, Google Dashboard shows some but not quite all of the data that Google has accrued about you – a...
2009-12-01
1,124 reads
I’ve been using Win 7 on my dev machine for a few months now, and finally decided over the Thanksgiving...
2009-12-01
503 reads
On the Friday at the end of the Summit we had a 4 hour Board meeting, welcoming new board members...
2009-11-30
1,743 reads
I met Rob via email early this year as a volunteer helping with content for PASS, and I’ve been following...
2009-11-29
1,417 reads
Brian Moran (incoming Board member) did a nice interview with Kevin, worth reading, and some good stuff about areas where...
2009-11-29
1,385 reads
Ran across this list a while back, Jurgen posted his Top 200 Developer Blogs list and an OPML file of...
2009-11-29
1,400 reads
I’m fond of browsing the discount shelf at the bookstore, it’s another way to see books that I might otherwise...
2009-11-26
577 reads
I know Thanksgiving has some deeper meanings, but at one level it’s all about the food. Food is a good...
2009-11-25
609 reads
Earlier this week I posted Part 1 and Part 2, today I want to wrap up by thinking about how...
2009-11-24
567 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