Two Weeks on the PASS Board
The one absolute promise I made about serving on the PASS Board is that I would let you know what...
2015-01-16
529 reads
The one absolute promise I made about serving on the PASS Board is that I would let you know what...
2015-01-16
529 reads
A while back I wrote about saying “Thank you” to people. Last night I was listening to NPR on my...
2015-01-09
692 reads
This is me on the last cruise
In just a few more weeks I’ll be setting sail on the first of...
2015-01-06
1,085 reads
I love it that my first post of the new year is going to be Speaker of the Month. I’m...
2015-01-02
428 reads
If you get an execution plan that looks like this:
I wouldn’t blame you for immediately thinking about query tuning. Especially...
2014-12-29 (first published: 2014-12-19)
6,158 reads
For the month of November I was at the PASS Summit and Live360, so I didn’t get to find new...
2014-12-08
552 reads
I have been very remiss in my blogging of late. Apologies.
One thing I haven’t blogged about is Speaker of...
2014-12-05
505 reads
For the first time ever at the PASS Summit, a competition was held to select a speaker for the 2015...
2014-11-13
780 reads
I’m just back from the PASS Summit 2014. What a great event. But this year, it was a little different....
2014-11-11
699 reads
Since I’m starting on the board in January, I’ve stopped taking part in the bloggers table during keynotes. First time...
2014-11-06
621 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