Do you Dream?
You ever have those nights consumed by all things SQL? I do. It happens more than I might like sometimes. Usually it happens when there is a work problem...
2012-10-11
8 reads
You ever have those nights consumed by all things SQL? I do. It happens more than I might like sometimes. Usually it happens when there is a work problem...
2012-10-11
8 reads
High Energy Plankton
In 2022 humans will finally have become their own worst enemies/frenemies. No matter how hard Gore works to...
2012-10-09
1,088 reads
So, what I’d like to know is, what is your most horrifying discovery from your work with SQL Server?
Related Posts:
Data Platform MVP 2020 August 12, 2020
It's an Honor:...
2012-10-09
3 reads
Last month I blogged about my absence from the blogosphere. If you want, you can read about it again – here....
2012-10-04
943 reads
Last month I blogged about my absence from the blogosphere. If you want, you can read about it again – here. Granted, it has been a month and I...
2012-10-04
2 reads
Do your database users appear to be having an out of body experience? Have they lost all ties to their...
2012-10-03
1,078 reads
Do your database users appear to be having an out of body experience? Have they lost all ties to their login? Does it feel like maybe what this baby...
2012-10-03
4 reads
2012-09-28
2,067 reads
2012-09-24
2,020 reads
Wow, I can’t believe it is already September of 2012. Labor day has come and gone, school is in session...
2012-09-04
889 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...
Tlp/Wa_Cs:0817-866-887. Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, RT.1/RW.5, Menteng, Kec. Menteng, Kota...
WhatsApp:0818-751-777 Gedung Gajah Tebet, Jl. Dr. Saharjo No.Raya 111 Unit N & O, RT.1/RW.1,...
When things go wrong - like trouble signing in, videos pausing, unclear charges, or...
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