Picking a Blog Platform
For the past couple years I’ve been using Community Server for blogging, only because that’s the platform that’s been part...
2010-01-06
1,152 reads
For the past couple years I’ve been using Community Server for blogging, only because that’s the platform that’s been part...
2010-01-06
1,152 reads
Posting goals online is great as long as you meet your goals, can be something less than great if you...
2010-01-05
808 reads
Not easy to find yet on the new site, you can find it at http://www.sqlandy.com/feed/.
2010-01-05
316 reads
Bill Graziano posted some thoughts about the merits of East Coast vs West Coast placement of the Summit. He did...
2010-01-05
374 reads
I’ve been ‘on vacation’ for two weeks and it’s been nice to relax. I wasn’t able to unplug entirely, but...
2010-01-04
457 reads
I’ve moved my blog to www.sqlandy.com and the first post of 2010 is up. It’s still very much a work...
2010-01-02
289 reads
I started blogging about 2-1/2 years ago on SQLServerCentral.com and at the time it was the logical place for hosting....
2010-01-01
327 reads
I think I’ve met my goal of blogging every day. I’m at almost 800 posts now over the past 2.5...
2009-12-30
1,406 reads
I had a student recently who said that to get any type of training she had to write a proposal...
2009-12-29
1,544 reads
Funny the things you don’t think about until you hear someone doing it a different way. In this case it...
2009-12-28
566 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...
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