Silliness for an Important Cause
I don’t mind saying that amyotrophic lateral sclerosis (ALS), also known as Lou Gehrig’s disease, scares me. A degenerative disease...
2014-08-21
1,237 reads
I don’t mind saying that amyotrophic lateral sclerosis (ALS), also known as Lou Gehrig’s disease, scares me. A degenerative disease...
2014-08-21
1,237 reads
As companies go, Red Gate is a little different. That is readily apparent in our tools and the philosophy behind...
2014-08-20
756 reads
A discussion that I’ve frequently had with organizers of SQL Saturday events, our own people here at Red Gate, authors,...
2014-08-19
566 reads
I’m excited to able to say that I’ve been given the opportunity to put on a full day workshop at...
2014-08-14
811 reads
I was approached by a man at SQL Bits who only wanted to thank me for blogging. He said, “I...
2014-08-13 (first published: 2014-08-06)
8,115 reads
Speaker of the Month is now officially one year old.
I went back and reread my first post. The goals were...
2014-08-08 (first published: 2014-08-01)
7,055 reads
There seemed to be some question whether my comfort level with my own masculinity would prevent me from wearing these:
Oh...
2014-07-23
706 reads
I took part in the PASS Summit 2014 selection committee this year because I was really curious about seeing how...
2014-07-21
671 reads
I wouldn’t say it’s common knowledge that you should look at execution plans when tuning queries, but it’s not exactly...
2014-07-17 (first published: 2014-07-15)
10,306 reads
Another month another bunch of great presentations. I almost don’t want to do this any more. It’s hard. I sit...
2014-07-11
565 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...
Bantuan Cs 0817839777 Jl. Mayjen HR. Muhammad No.17, Putat Gede, Kec. Sukomanunggal, Surabaya, Jawa...
Telp / Wa 0817839777 Jl. Mayjend. Jonosewojo No.14, Pradahkalikendal, Kec. Dukuhpakis, Surabaya, Jawa Timur...
Cs: 0817839777 Jl. Ahmad Yani No.39 A, Rw1, Sidokumpul, Kec. Sidoarjo, Kabupaten Sidoarjo, Jawa...
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