Daily Coping 17 Nov 2022
Today’s coping tip is to try out a new way of being physically active. My routine for physical activity is yoga 2-3 times a week, weight lifting a couple...
2022-11-17
21 reads
Today’s coping tip is to try out a new way of being physically active. My routine for physical activity is yoga 2-3 times a week, weight lifting a couple...
2022-11-17
21 reads
Today’s coping tip is to change your normal routine today and notice how you feel. I am a person who likes a routine. While I travel a lot and...
2022-11-16
21 reads
I’m part of a Redgate promotion at the PASS Data Community Summit. They ordered some Lego Steve’s, which will be available at the booth. You can post some photos...
2022-11-16
27 reads
When I first started work as a software developer, I knew that getting an environment set up where I could compile a project might take a few hours or a few days. The complexities of how people built software projects, the dependencies, and more were handled in a very immature manner. These days I can […]
2022-11-16
214 reads
2022-11-16
426 reads
Today’s coping tip is to sign up to try a new activity, course, or community. I somewhat did this early in the fall by choosing to go through the...
2022-11-15
23 reads
Today’s coping tip is to get outside and observe the changes in nature around you . Nature is changing in Colorado as winter approaches. It’s been a dry year,...
2022-11-14
23 reads
My journey might be somewhat unusual, but perhaps not. I started writing articles on the Internet at a few different places before I started SQL Server Central. There were...
2022-11-14 (first published: 2022-11-01)
95 reads
Many of us have learned how to research and get new information online. I certainly think the written word, whether from formal articles at places like SQL Server Central...
2022-11-14
9 reads
Building software means not only considering the data people expect, but also edge cases. Steve asks if you know what those edge cases are?
2022-11-14
294 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...
Bantuan Cs 0817839777 Jl. Mayjen HR. Muhammad No.17, Putat Gede, Kec. Sukomanunggal, Surabaya, Jawa...
Telp / Wa 0817839777 Jl. Mayjend. Jonosewojo No.14, Pradahkalikendal, Kec. Dukuhpakis, Surabaya, Jawa Timur...
Cs: 0817839777 Jl. Ahmad Yani No.39 A, Rw1, Sidokumpul, Kec. Sidoarjo, Kabupaten Sidoarjo, Jawa...
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