PASS Update #24
Time to update you again on all things PASS. First, I haven’t made a lot of progress on the speaker...
2010-03-05
537 reads
Time to update you again on all things PASS. First, I haven’t made a lot of progress on the speaker...
2010-03-05
537 reads
Final schedule for the Charlotte event and it is impressive – 9 tracks, 54 sessions!
2010-03-04
513 reads
The title of this post illustrates my own ambiguity on the topic. It’s fair and necessary to let others know...
2010-03-04
626 reads
Drove down with the family Friday afternoon, not much traffic and a smooth trip. Checked into the Residence Inn just...
2010-03-03
456 reads
Andrew Karcher and Marlon Ribunal are heading up SQLSaturday #44 scheduled for April 24, 2010 at Golden West College in...
2010-03-03
337 reads
I’ve written about a few ‘worst practices’ over the years to call attention to some things that are bad (or...
2010-03-03
3,284 reads
Saw the announcement by accident while doing some browsing on Amazon. Thought I’d try it out just to see. Download...
2010-03-02
229 reads
I’ve written about a few ‘worst practices’ over the years to call attention to some things that are bad (or...
2010-03-01
1,584 reads
Just finished re-reading Orbit ($15 or less at Amazon) after picking it up for a $1 at Books a Million...
2010-02-26
1,570 reads
About a week ago I wrote Part 1, and got some interesting feedback (which I appreciate). Today I want to...
2010-02-25
864 reads
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...
By gbargsley
One of the first things I review when I inherit a new SQL Server...
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