A New Stressor
I tend to be amused when I run into something that causes me stress because I like to think – foolishly...
2014-04-30
1,428 reads
I tend to be amused when I run into something that causes me stress because I like to think – foolishly...
2014-04-30
1,428 reads
Not to short change fund raising, but the toughest goal to meet for this year is registration/attendance if we’re going...
2014-04-30
1,525 reads
Our attendance number for last year was 285, so we’re going to aim for increasing that by 20% to 342....
2014-04-29
1,364 reads
Our attendance number for last year was 285, so we’re going to aim for increasing that by 20% to 342....
2014-04-29
1,293 reads
I’ve committed to presenting but haven’t decided on the presentation yet. It will probably be a remote presentation because it’s...
2014-04-29
1,268 reads
I saw this write up about Aaron Sorkin and the writing on Newsroom just after posting Blogging-Write More and found...
2014-04-28
638 reads
Yesterday I submitted a new question of the day based on the best idea generator you can find – something that...
2014-04-24
563 reads
Same room but different seating arrangement. Instead of separate table pushed some together, used the space better and more a...
2014-04-21
519 reads
I’m presenting tonight at oPASS, two presentations worth! If you’re in Orlando I hope you’ll attend, details at http://orlando.sqlpass.org/.
2014-04-17
530 reads
Kevin Kline is speaking at MagicPASS tonight – on two topics! If you’re in the Orlando area I hope you’ll try...
2014-04-16
534 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