Minimalist Design
I'm been in tactical mode lately, building an advertising management system for one of our projects. Actually it's v2, the...
2009-03-25
1,608 reads
I'm been in tactical mode lately, building an advertising management system for one of our projects. Actually it's v2, the...
2009-03-25
1,608 reads
Yesterday I was commenting on how a big part of stress for me is getting that sudden burst of work...
2009-03-24
827 reads
Registration has been open since the last Summit, but this year Bill Graziano and team have released the Summit 2009...
2009-03-24
587 reads
In this SQL School video, learn how the UNION statement can help you join together results from different queries. MVP Andy Warren explains this T-SQL statement.
2009-03-24
6,822 reads
The call for speakers is open through midnight on April 10, 2009, so get busy submitting those abstracts! Work hard on the title and description, make it something that seems interesting and compelling for attendees. Expect the competition to be fierce...The call for speakers is open through midnight on April 10, 2009, so get busy submitting those abstracts! Work hard on the title and description, make it something that seems interesting and compelling for attendees. Expect the competition to be fierce...
2009-03-24
950 reads
As I gain more experience I've found that stress comes in three forms; stress that is there that you don't...
2009-03-23
582 reads
The call for speakers is open through midnight on April 10, 2009, so get busy submitting those abstracts! Work hard...
2009-03-22
746 reads
I was browsing the March 2009 issue of Visual Studio Magazine today and found that it's changing again. It's been...
2009-03-19
778 reads
This SQL School video shows how you can speed up your backup process by striping the backup across multiple disks. MVP Andy Warren narrates.
2009-03-19
3,633 reads
I've been slowly looking at and experimenting with LinkedIn to see if it has value and if so, how to...
2009-03-19
912 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