Jumpstart TV Video
If you are new to SQL Server, you might be interested in viewing a video that covers the terms you use...
2006-09-11
1,585 reads
If you are new to SQL Server, you might be interested in viewing a video that covers the terms you use...
2006-09-11
1,585 reads
I ordered some new drives for our Dell server from "This Old Store" recently and they came on Tuesday of...
2006-09-08
1,699 reads
I've not been posting over the last week because I'm in the midst of a
two week vacation, the first I've...
2006-09-01
1,458 reads
Generally I don't look forward to giving up an entire Saturday at work. However, today's Dallas Code Camp was an...
2006-08-29
1,585 reads
As I indicated in my previous post, Visual Studio Team System for Database Professionals CTP 5 Out,
if you don't already...
2006-08-24
1,385 reads
Under the category of working too fast, today's downtime was brought to you by me.
I've been working an issue with...
2006-08-23
1,443 reads
If you aren't aware, the Visual Studio Team System for Database
Professionals CTP 5 is available for download. It's a significantly
larger...
2006-08-23
1,429 reads
I was working with a developer the other day and the question came up
of how to return status from a...
2006-08-17
1,825 reads
OK, it's been a long time since I made an entry here, mostly because I've been busy and keep forgetting...
2006-08-15
1,415 reads
2006-08-09
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