Building My Next Workstation–Part 5
With the motherboard and CPU installed I was ready to add the final and perhaps easiest parts to the build....
2013-03-11
659 reads
With the motherboard and CPU installed I was ready to add the final and perhaps easiest parts to the build....
2013-03-11
659 reads
Reading about the motherboard choices took a while. Because I had already decided on a CPU, the Intel I7 I...
2013-03-07
784 reads
I saw it in the Connector, but just had time to read the minutes to see what was behind the...
2013-03-06
862 reads
With a case ordered and a CPU in mind I decided to focus on the power supply next. Remember that...
2013-03-05
656 reads
I was reading about the American Association of Woodturners annual symposium that will be held in Tampa this year (and...
2013-03-05
638 reads
This past weekend I was back in Tampa for the sixth annual SQLSaturday. It’s a trip I always look forward...
2013-03-04
656 reads
One of the minor features/quirks/annoyances of MS Access is that if you create a single macro or code module you...
2013-03-04
683 reads
Building a computer, at least in the beginning, feels like something you have to do holistically and at the same...
2013-02-25
1,259 reads
It’s been four years – maybe more – since I last bought a workstation to use for development and lab work. It’s...
2013-02-18
746 reads
My Nexus 7 tablet has grown on me, though I think it’s more about having a dedicated tablet than the...
2013-02-14
623 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