Another User Has Locked My File!
I had an SSIS package fail in a script task this morning. As part of the why process I opened...
2014-05-07
346 reads
I had an SSIS package fail in a script task this morning. As part of the why process I opened...
2014-05-07
346 reads
Quick thoughts about the work required to make all day meetings run smoothly:
Suitable space with enough seating (and reasonable chairs!)Turn...
2014-05-07 (first published: 2014-05-01)
1,379 reads
My latest question Datatypes In Your Mind is live today and it’s generated quite the discussion. I wrote here about...
2014-05-06
470 reads
2014-05-06
2,169 reads
When building a system, you need to make choices. However, do you always need to make the choice of only two of the three "good, fast, or cheap" choices? Andy Warren has a few thoughts.
2014-05-05
215 reads
Better, Faster, and Cheaper was published today and I hope you’ll read it, and then challenge your own assumptions for...
2014-05-05
627 reads
Blogging isn’t easy. You have to come up with a topic, write about it, and then release it for the...
2014-05-02 (first published: 2014-04-22)
1,494 reads
More notes, many from a chat with Kendal.
We wish we could see the open rate on email and an...
2014-05-02
324 reads
Seminars (aka “pre-cons”) have been part of the DNA of SQLSaturday going back to #1. For those that weren’t there...
2014-05-02
487 reads
I spent some more time last night thinking about the event and marketing it. Biased I am, but I think...
2014-05-01
634 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