PASSMN–Passing the Baton: A Board Transition Story
Each year the Minnesota SQL Server User Group elects new board members and resets its leadership team. I have been...
2012-12-12
777 reads
Each year the Minnesota SQL Server User Group elects new board members and resets its leadership team. I have been...
2012-12-12
777 reads
Wow, what a week. Once again, PASS put on a great event that provided much in the way of events...
2012-11-13
872 reads
Reblogged from Data on Wheels - Steve Hughes: I recently completed a series of blog posts on www.lessthandot.com on T-SQL Window...
2012-11-12
627 reads
IT’S MONDAY! You ready to enjoy the fun and to learn a bunch? I know I am. Besides my schedule...
2012-11-05
677 reads
I assume at this point some of you are already in Seattle and even getting ready to attend Preconference Sessions....
2012-11-04
646 reads
Three days to go. I need to get my schedule sorted out, how about you. What influences your schedule? Since...
2012-11-03
559 reads
Four days to the Summit. Will you be singing? Last year was my first time attending SQL Karaoke. While I...
2012-11-02
764 reads
Just 5 days to Summit kick off. Today’s discussion is about communities within the community. That’s right. There is more...
2012-11-01
586 reads
Getting closer, 6 days to Summit 2012! Today, I just have to give kudos out to Magenic, my current employer....
2012-10-31
1,236 reads
Seven days, one full week, until opening night at Summit 2012. Getting excited yet? In my first post of the...
2012-10-30
1,253 reads
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
WhatsApp CS 628218520154 Jl. Suryopranoto No.40, RT.12/RW.7, Petojo Utara, Kecamatan Gambir, Kota Jakarta Pusat,...
WhatsApp CS 628218520154 Jl. Pegangsaan Timur No.1, Cikini, Kec. Menteng, Kota Jakarta Pusat, Daerah...
WhatsApp CS 628218520154 Jl. Pintu Air Raya No.36 Q, RT.6/RW.1, Ps. Baru, Kecamatan Sawah...
I have some data in a SQL Server 2025 database. It looks like this for the dbo.Customer table:
CustomerID CustomerName PreferredName 1 Steve Steve 2 Andy Andy 3 Brian Brian 4 Allan Allan 5 Devin Devin 6 Steve Steve 7 Sally SallyI want to detect which names have a single trailing space. The CustomerName is a varchar() and the PreferredName is a CHAR(). Does this query detect the problem rows?
SELECT
CustomerID,
CustomerName,
PreferredName
FROM Customer
WHERE CustomerName <> RTRIM(CustomerName)
OR PreferredName <> RTRIM(PreferredName); See possible answers