Notes from the April 13, 2010 oPASS Meeting
Decided to scrap the pizza this month after one too many late deliveries from Pizza Hut, went with sandwich platters...
2010-04-14
489 reads
Decided to scrap the pizza this month after one too many late deliveries from Pizza Hut, went with sandwich platters...
2010-04-14
489 reads
SQLSaturday #46 will be held in Raleigh, NC on September 18, 2010, under the direction of Brett Tomson and team...
2010-04-13
487 reads
Our next meeting is today, April 9, 2010, from 6-8 pm. Our featured speaker is Joe Webb and he’ll be...
2010-04-13
243 reads
The minutes from the March 2010 Board meeting were released last week and I hope you’ll review them carefully. Viewing...
2010-04-13
467 reads
Just set up SQLSaturday #47 in Phoenix for July 17, 2010 at Devry. Call for speakers is open, good to...
2010-04-13
749 reads
Several weeks ago I was invited to attend a ‘tweetup’ by Microsoft on April 8th, an almost all expenses paid...
2010-04-12
438 reads
Sanj Gandham from PASS HQ set up a basic template for SQLSaturday presentations, you can download it from here. Our...
2010-04-12
736 reads
I did an hour or so call with Jack Corbett recently to review what we hope to accomplish this year....
2010-04-08
280 reads
A guest editorial from Andy Warren today looks at choices in time management, as well as work accomplished.
2010-04-08
123 reads
Life was busier than I would have liked this year, but made it to one game, Braves vs Tigers, for...
2010-04-08
279 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