I’m Attending SQLSaturday #51 in Nashville
I’ll actually be going up a couple days early for a PASS Board meeting, then shifting to speaker/attendee mode Friday...
2010-08-20
503 reads
I’ll actually be going up a couple days early for a PASS Board meeting, then shifting to speaker/attendee mode Friday...
2010-08-20
503 reads
In 2009 we had a contentious election cycle at PASS, and I won’t go through the details again, but because...
2010-08-20
654 reads
I found Career Warfare: 10 Rules for Building a Successful Personal Brand on the Business Battlefield by David D’Alessandro ($12@...
2010-08-19
899 reads
I’m flying to Nashville today for the Board meeting on August 19 and 20, 2010. I had already planned to...
2010-08-18
935 reads
I’ve been managing oPASS since we re-hydrated it back in early 2007. Seems like a long time ago! We’ve made...
2010-08-17
582 reads
Had my final follow up call with Don Gabor, took one more run through the networking and speaker stuff (Don...
2010-08-16
649 reads
I get a fair amount of email in a week; stuff about work, stuff for oPASS, stuff for PASS, stuff...
2010-08-13
577 reads
Today we have a guest editorial from Andy Warren that talks about the value of blogging.
2010-08-13
154 reads
I wrote the value of blogging hoping to highlight the less often discussed value of practicing writing. Too often we...
2010-08-13
580 reads
Passing along this contest from Idera and MSSQLTips. I don’t do many plugs, but it’s a chance for someone to...
2010-08-11
788 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