PASS Update #26 (Bylaws & Upcoming Board Meeting)
Most months we do a conference call, but a couple times a year we get to meet in person and...
2010-03-16
598 reads
Most months we do a conference call, but a couple times a year we get to meet in person and...
2010-03-16
598 reads
It’s pretty common to download software as an ISO file (a disk image) and it seems like a waste to...
2010-03-15
781 reads
My wife and I try to have dinner out every other week or so, but we tend to fall into...
2010-03-12
771 reads
I’ll be attending and speaking at the Orlando Code Camp on March 27, 2010 at Seminole State College along with...
2010-03-12
554 reads
By now you’ve probably seen the official announcement from PASS about the Summit being located in Seattle for both 2011...
2010-03-11
675 reads
I’m in charge of networking and social time for oPASS and I do what I can to help get our...
2010-03-11
508 reads
We put this together last year and we’re up to 270 blogs listed, but I’m sure we’re still missing some,...
2010-03-10
513 reads
Saw this article about more elbow room, the premise being that is it is often cheaper to buy a second...
2010-03-09
353 reads
I did the relatively quick flight to Charlotte on Friday afternoon, arriving just before 2 pm, grabbed lunch to go...
2010-03-08
303 reads
I’m flying up Friday afternoon for SQLSaturday #33. Looking forward to the trip, Charlotte is a great area and I...
2010-03-05
392 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