T-SQL Tuesday Topics – Feb 2011
I was looking for a static list of all the T-SQL Tuesday topics and couldn’t find one. The domain moves...
2011-02-11
899 reads
I was looking for a static list of all the T-SQL Tuesday topics and couldn’t find one. The domain moves...
2011-02-11
899 reads
Support for SQL Server 2005 expires in April. Should you care? Steve Jones thinks it might not be a big deal for many people.
2011-02-10
356 reads
Sometimes, usually when I’m editing video, I see myself do something silly. Today was one of those times, and these...
2011-02-09
706 reads
Are there things you should know? It seems that we quite often find that others in our profession don't understand the simple things we assume they do. Steve Jones talks about one item in particular: staging servers.
2011-02-09
310 reads
2011-02-09
2,142 reads
The way we input data is changing with the advent of the iPad and tablets. Is that good or bad for the acquisition of data? Steve Jones has a few thoughts today.
2011-02-08
190 reads
It’s that time of the month again, and this month Pat Wright and his SQL Asylum are hosting the T-SQL...
2011-02-08
1,020 reads
2011-02-08
2,749 reads
What do you do if you've lied to get a job and now are in a bad position? Steve Jones offers his advice today.
2011-02-07
590 reads
In the early days of SQL Server you could not run a log backup while a full backup was running....
2011-02-07
1,926 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