2023-11-17 (first published: 2017-12-08)
436 reads
2023-11-17 (first published: 2017-12-08)
436 reads
I had someone ask this question recently and had to double check the syntax myself, so I thought this would make a nice SQL New Blogger post. Another post...
2023-11-15 (first published: 2023-10-30)
352 reads
2023-11-15 (first published: 2017-12-05)
194 reads
2023-11-15
391 reads
I suspect many people assume this is the case, but a customer recently asked if SQL Compare handles indexes. It does, and this post shows the basics of index...
2023-11-15
178 reads
I am the host for T-SQL Tuesday this month, and I hope that a lot of people like the topic. This idea actually came to me earlier this year...
2023-11-14
59 reads
I’m up in Seattle this week for the PASS Data Community Summit 2023. This is almost an annual event for me. I’ve missed a few since 1999, but not...
2023-11-13
15 reads
The idea of working on just projects is tailor made for a data professional. Or is it?
2023-11-13 (first published: 2017-10-24)
205 reads
2023-11-13
418 reads
Steve doesn't think you need a degree to work in technology and more companies agree with this all the time.
2023-11-11
95 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...
When things go wrong - like trouble signing in, videos pausing, unclear charges, or...
Tlp/Wa_Cs:0817-866-887. Jl. Lenteng Agung Raya No.26 E-F, RT.1/RW.4, Ps. Minggu, Kota Jakarta Selatan, Daerah...
Tlp/Wa_Cs:0817-866-887. Centennial Tower, Jl. Gatot Subroto No.Kav 24-25 lantai GF unit C, RT.2/RW.2, Karet...
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