Dell Mini – The Follow Up
Back in January I posted about purchasing a Dell Mini 9, wanting to see what how it worked and a...
2009-06-24
1,378 reads
Back in January I posted about purchasing a Dell Mini 9, wanting to see what how it worked and a...
2009-06-24
1,378 reads
Part 1 discussed ways to find opportunities, Part 2 was about how to get more interviews, and today we’ll cover some tips from the employer perspective. Don’t use an AOL.com email address. Seriously. Gmail, Live, Yahoo, all are good, but AOL.com makes...
2009-06-24
2,538 reads
In this SQL School video, Andy Warren shows how you can alter a table to add a computed column. This is part 1 of 2.
2009-06-23
4,650 reads
Saw this in email this morning, Clear has ceased operations after failing to negotiate with its senior creditor. I’ve written...
2009-06-23
630 reads
As happens occasionally I had a stack of books on my desk that needed to be put away, and as...
2009-06-23
531 reads
Yesterday I posted Part 1 containing five ideas for those looking for work. Today I’m going to focus on what to do when you’re struggling to get interviews. Your chances of getting hired for any given job once you interview are perhaps 1 in 10 (an unscientific...
2009-06-23
2,333 reads
My friend Robert Cain was kind enough to include me on his list of big thinkers along with my business...
2009-06-22
808 reads
Getting a job is hard. If you’ve been lucky enough not to struggle for a job, don’t make the mistake...
2009-06-22
1,226 reads
I think the hardest part about the job search is interviewing and not being selected. You keep saying “why” with...
2009-06-22
616 reads
Learn how you can create your own data types in this SQL School video. MVP Andy Warren explains the process of setting up user-defined data types.
2009-06-18
3,970 reads
By Steve Jones
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...
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...
Bantuan Cs 0817839777 Jl. Mayjen HR. Muhammad No.17, Putat Gede, Kec. Sukomanunggal, Surabaya, Jawa...
Telp / Wa 0817839777 Jl. Mayjend. Jonosewojo No.14, Pradahkalikendal, Kec. Dukuhpakis, Surabaya, Jawa Timur...
Cs: 0817839777 Jl. Ahmad Yani No.39 A, Rw1, Sidokumpul, Kec. Sidoarjo, Kabupaten Sidoarjo, Jawa...
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