T-SQL Tuesday #024: Prox ‘n’ Funx
Functions are very handy. They can also prove to be the cause of poor performance (such as was the case with that string splitter). When used appropriately, you can...
2011-11-08
5 reads
Functions are very handy. They can also prove to be the cause of poor performance (such as was the case with that string splitter). When used appropriately, you can...
2011-11-08
5 reads
I find myself just now sitting down to write this as the deadline for TSQL Tuesday 24 fast approaches. Fortunately...
2011-11-08
662 reads
Meme Monday, What #SQLFamily means to me personally.
Tom LaRock Is kicking of November with this particular meme. I’m not sure exactly...
2011-11-08
846 reads
I was using various “quick find” SSMS add-ins which give you ability to get your tables, stored procedures, functions and...
2011-11-07
1,023 reads
As part of my commitment to read and review 12 books in an effort to be active in my own...
2011-11-07
1,770 reads
Providing delegated administration to groups that need to perform various security functions has always been a difficult task, but thanks...
2011-11-07
2,677 reads
Microsoft has released SQL Server 2010 Developer Training Kit which includes :
LabsDemosand, Presentations
This kit will greatly help you learning Developer...
2011-11-07
830 reads
I was recently in a conversation with several people that had previously organized one or more community events. The topic evolved into a discussion of Sponsors, and eventually, fund...
2011-11-07
10 reads
I was recently in a conversation with several people that had previously organized one or more community events. The topic...
2011-11-07
886 reads
I was recently in a conversation with several people that had previously organized one or more community events. The topic evolved into a discussion of Sponsors, and eventually, fund...
2011-11-07
5 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...
Kontak Cs: 0817839777 Jl. Kartini No.98 B-100, Injen Barat, Tlogobendung, Kec. Gresik, Kabupaten Gresik,...
Kontak Cs: 0817839777 Jl. Veteran No.18-24, Krembangan Sel., Kec. Krembangan, Surabaya, Jawa Timur 60175
Kontak Cs: 0817839777 Jl. HOS. Cokro Aminoto No.5, Mergelo, Jagalan, Kec. Magersari, Kota Mojokerto,...
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