Interfaces
The interface is crucial for getting data in and out of a system. Steve Jones talks a little about past interfaces and possible future ones.
2009-04-22
887 reads
The interface is crucial for getting data in and out of a system. Steve Jones talks a little about past interfaces and possible future ones.
2009-04-22
887 reads
The interface is crucial for getting data in and out of a system. Steve Jones talks a little about past interfaces and possible future ones.
2009-04-22
704 reads
The interface is crucial for getting data in and out of a system. Steve Jones talks a little about past interfaces and possible future ones.
2009-04-22
667 reads
I read SQLBatman's post about his first week as an MVP , and it really resonated well with me. I think that he really hit it when he said that he wasn't going to sit around, he was going to go look for information and take things back from the...
2009-04-22
1,226 reads
I worked at a company that had a yearly bonus. Actually I’ve worked at a few companies, but this one...
2009-04-21
763 reads
My wife has had a hard week. Actually a few weeks where she's worked a lot of hours, lots of...
2009-04-21
683 reads
With the economy in a downturn, Steve Jones talks about what you might want to do to be pro-active with your projects.
2009-04-21
106 reads
The person responsible for your career is you. Steve Jones gives you a few thoughts on how you might approach your career.
2009-04-21
202 reads
The person responsible for your career is you. Steve Jones gives you a few thoughts on how you might approach your career.
2009-04-21
283 reads
The person responsible for your career is you. Steve Jones gives you a few thoughts on how you might approach your career.
2009-04-21
161 reads
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...
By davebem
I’ve had a Dropbox account for years. Like a lot of people, I started...
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...
Comments posted to this topic are about the item Detecting Characters
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