Another use of OpenRowSet()
From time to time, I need to dump out the result from a SP, such as sp_lock or sp_who.
Traditionally,...
2007-11-29
1,410 reads
From time to time, I need to dump out the result from a SP, such as sp_lock or sp_who.
Traditionally,...
2007-11-29
1,410 reads
It's funny - sorta - how you become used to the quirks of the tools you. I try not to rant too...
2007-11-29
1,411 reads
I was having this discussion recently with Shawn Weisfeld, President of ONETUG and it's definitely a frustrating topic. As a...
2007-11-28
1,421 reads
I was reading an interview with Jimmy Wales (the Wikipedia guy) in Selling Power magazine (I have ecletic reading preferences...
2007-11-26
1,363 reads
CIO Magazine has a interesting article about Douglas Merrill, the CIO of Google. One of the things he dicusses in...
2007-11-26
1,705 reads
After putting it off for six months, I finally took - and passed - 70-431 yesterday. I know, I'm probably one of...
2007-11-25
1,447 reads
As a follow up to my post about Cesar Cerrudo's new whitepaper, earlier this month David Litchfield talked about putting...
2007-11-23
2,349 reads
Cesar Cerrudo of Argeniss Information Security has put out a new whitepaper (.pdf format), Data0: Next generation malware for stealing...
2007-11-23
1,974 reads
For the page 10 months or so I've been using a Samsung Blackjack, before that I used various Blackberries for...
2007-11-21
1,435 reads
I solved an "interesting" issue today. It is about distributed transaction. When I set up transactional replication with immediate updating...
2007-11-21
3,665 reads
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...
By davebem
I’ve had a Dropbox account for years. Like a lot of people, I started...
WhatsApp:0818-751-777 Gedung Gajah Tebet, Jl. Dr. Saharjo No.Raya 111 Unit N & O, RT.1/RW.1,...
When things go wrong - like trouble signing in, videos pausing, unclear charges, or...
Tlp/Wa_Cs:0817-866-887. Jl. Lenteng Agung Raya No.26 E-F, RT.1/RW.4, Ps. Minggu, Kota Jakarta Selatan, Daerah...
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