Closing Down SQLGroups.com
We (Brian, Steve, and I) provided hosting for SQL chapters going way back…maybe 2002 or 2003, on behalf of PASS....
2009-07-27
534 reads
We (Brian, Steve, and I) provided hosting for SQL chapters going way back…maybe 2002 or 2003, on behalf of PASS....
2009-07-27
534 reads
Sometime in the next couple weeks will mark the beginning of the 30 day period where we accept nominations for the...
2009-07-26
1,008 reads
Steve Lane and team from Tallahassee are hosting their annual Code Camp on Sep 5, 2009, and have asked if...
2009-07-26
661 reads
Stuart Ainsworth is launching SQLSaturday #24 & #25, both in Gainesville, GA on October 9th and 10th respectively, and yes, one...
2009-07-24
642 reads
Found The Candy Bombers: The Untold Story of the Berlin Airlift and America's Finest Hour by Andrei Cherny ($20 @ Amazon) ...
2009-07-23
550 reads
Continuing with his videos on Foreign Keys, MVP Andy Warren shows us how to set constraints between two tables.
2009-07-23
5,039 reads
This month I’m featuring Glenn Berry, a Denver based MVP that writes Glenn Berry's SQL Server Performance blog. He blogs...
2009-07-22
730 reads
MSSQLTips & Idera are sponsoring a contest where the grand prize in an all expenses paid trip to the PASS Summit...
2009-07-21
711 reads
Understanding referential integrity is important for anyone working with databases. It can help you design better forming systems. Learn the basics of foreign keys in this SQL School video.
2009-07-21
8,614 reads
Time for another update on all things PASS. I’ve been struggling to find time for PASS activities and having to...
2009-07-21
609 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