Is $160 Per Day a Lot?
Recently I was in a small coffee/sandwich shop for early morning coffee and while waiting watched one of the employees...
2013-06-17
753 reads
Recently I was in a small coffee/sandwich shop for early morning coffee and while waiting watched one of the employees...
2013-06-17
753 reads
Since I bought a Nexus 7 (two of them, I broke the first one) I’ve been interested to see if...
2013-06-17
621 reads
First stop was Philadelphia, mostly because we scheduled our vacation to coincide with SQLSaturday #200, but also because we had...
2013-06-11
922 reads
My first time in Philadelphia (and in Malvern, the actual event location). I drove up Friday night for the speaker...
2013-06-07
775 reads
I’ll be attending the very first SQLSaturday held in Cocoa Beach on July 27, 2013, and doing a brand new...
2013-06-07
623 reads
This past week I took my kids on a train ride from Philadelphia to Washington DC. It was their first...
2013-06-07
614 reads
At the end of April I posted a bit on my change in plans and what I thought I’d be...
2013-05-28
792 reads
Last week I got the news that none of the four sessions I submitted for this year were accepted. Disappointing...
2013-05-22
682 reads
I shifted to Reader about a year ago mainly for the ability to access my feeds on multiple devices. I’ll...
2013-05-16
636 reads
If you work at a company with more than a 100 or so employees you probably get an email every...
2013-05-16
628 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