Looking for SQL Speakers Near Wheeling, WV
I had a great call with John Sterrett last week about the possibility of having a SQLSaturday in Wheeling and...
2009-08-19
920 reads
I had a great call with John Sterrett last week about the possibility of having a SQLSaturday in Wheeling and...
2009-08-19
920 reads
Ran across this in a recent class while covering partitioning. Start by creating a standard partitioning function and the scheme,...
2009-08-19
2,495 reads
I’ve had this link about four kinds of free (and this link too) on my list for awhile, today seems...
2009-08-18
658 reads
Jack Corbett sent me an email this morning about the Swiss SQLSaturday, very cool! They did a great job on...
2009-08-18
745 reads
I’ve touched on it some in the past, but it’s a question that comes up a lot when we discuss...
2009-08-17
1,260 reads
Not obvious how to do this, go to http://www.regonline.com/Checkin.asp?EventId=685107, login, then click on Agenda. You can then add any of...
2009-08-17
761 reads
Posted today, Andy Leonard is the second person on the Council, and we’re glad to have him. Read the announcement...
2009-08-17
641 reads
We’ve just posted our core guidelines for technical content on sqlpass.org. The short story is there are three main ways...
2009-08-17
976 reads
The Coldest Winter: America and the Korean War by David Halberstam ($15 at Amazon) was really the first reading I...
2009-08-14
699 reads
The official announcement was just posted, Kevin Kline is the first member of the Advisory Council. As I mentioned on...
2009-08-14
1,046 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...
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
Comments posted to this topic are about the item What Happens When You Ask...
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