Never say 'never' to the WHILE loop.
/* download the test text file Moby-Dyck.zip here */
/* You might notice that I refer to Moby **** in this blog. This is because the busybodyish...
2008-10-02
2,239 reads
/* download the test text file Moby-Dyck.zip here */
/* You might notice that I refer to Moby **** in this blog. This is because the busybodyish...
2008-10-02
2,239 reads
The PASS Community Summit 2008 is coming up fast (November 18-21, 2008), and if you are attending and you are...
2008-10-01
601 reads
I think everyone struggles with keeping track of things they need to do, and it's all too easy to get...
2008-10-01
478 reads
Speaker: SQL Server MVP Andy Leonard
Midlands PASS Chapter - October 2, 2008 Meeting
The Midlands PASS chapter will hold our normally scheduled...
2008-10-01
925 reads
As I have been talking to DBAs around the country, I have noticed a trend that many, if not most,...
2008-10-01
371 reads
I don't seem to find the time often, but recently I was able to fit in another visit to the...
2008-09-30
1,376 reads
I've used Amazon for years for the sheer convenience, and recently was the first time I ever needed to return...
2008-09-29
1,464 reads
Make sure you make it to the next SQL Saturday event that I will be speaking at October 25, 2008...
2008-09-29
1,303 reads
Always something going wrong around here with the podcasts. Today I was editing a couple, or attempting to, and couldn't...
2008-09-29
1,443 reads
Why did I write this? I got challenged by Andy Warren
to write a bit about why I wrote something. I...
2008-09-29
1,361 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