SQLSaturday #37 in Philadelphia Announced
SQLSaturday #37 will be held March 13, 2010 at Mandeville Hall, St. Joseph's University, 5600 City Line Ave, Philadelphia, PA....
2009-12-16
558 reads
SQLSaturday #37 will be held March 13, 2010 at Mandeville Hall, St. Joseph's University, 5600 City Line Ave, Philadelphia, PA....
2009-12-16
558 reads
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-12-15
582 reads
John Baldwin and Morgan Smith are going to repeat in Birmingham this year on Mar 27. They’ve got a great...
2009-12-15
600 reads
I had a question from a member of our local user group about options to get a legal copy of...
2009-12-15
743 reads
My friend Ryan Duclos just sent me a reminder about the upcoming Alabama Code Camp on January 23, 2010, in...
2009-12-14
685 reads
In Update #20 I mentioned that I was hoping to get the chapters portfolio for 2010. A few weeks have...
2009-12-14
724 reads
We started off our end of year meeting with our standard networking meet and greet. It’s going smoother, people are...
2009-12-13
561 reads
I’m closing in on vacation – finally – and one of the things I’ll have in the back of my head while...
2009-12-13
588 reads
Assuming no major problems at work, I’m heading to the South side of town the afternoon of Dec 14, 2009...
2009-12-11
387 reads
I continue to read biographies without a real direction, stumbling across an interesting event in one and following that to...
2009-12-10
319 reads
By James Serra
Once again there were a number of Microsoft Build announcements related to data and...
A good week ago I hosted the monthly T-SQL Tuesday blog party. I invited...
By Steve Jones
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...
Kontak Cs: 0817839777 Jl. HOS. Cokro Aminoto No.5, Mergelo, Jagalan, Kec. Magersari, Kota Mojokerto,...
I have an issue where I have a Bill of Material list of items...
Comments posted to this topic are about the item Follow Your Hunch
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