Speaker Gift for SQLSaturday #49
We’ve tried to move away from shirts as a speaker gift, most speakers have them so we only get them...
2010-10-12
508 reads
We’ve tried to move away from shirts as a speaker gift, most speakers have them so we only get them...
2010-10-12
508 reads
I had a question recently about how budgets work at PASS, and I think that’s something worth sharing, so I’m...
2010-10-11
521 reads
Great title for a post, isn’t it? Seems foolish, lazy, or worse to plan for failure, right? Yet, in the...
2010-10-08
315 reads
I found The Literacy Project at Google after seeing a local op-ed piece about literacy. I love to read, a...
2010-10-07
443 reads
Not often I do plugs here, but then again, it’s rare that I just get first class service, so read...
2010-10-07
386 reads
If you haven’t used it (and I rarely do myself), Ident_Current (‘tablename’) returns the last identity value generated across all...
2010-10-06
969 reads
See my previous post on the topic,or just go directly to the application.The application has full details, but MVP’s, Summit...
2010-10-05
359 reads
I wrote the editorial about great service after noticing a couple small but interesting customer service experiences during two trips....
2010-10-05
431 reads
Back in 2007 when we started SQLSaturday we had the good luck to leverage an existing relationship between Seminole Community...
2010-10-04
756 reads
I drove up on Friday, just under 7 hours with a couple quick stops on the trip. Listened to Team...
2010-10-04
510 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