Raising the Bar
Turning up the heat. Take it up a notch. Stepping up to the plate. Less talk, more action.
However you choose...
2008-11-24
1,646 reads
Turning up the heat. Take it up a notch. Stepping up to the plate. Less talk, more action.
However you choose...
2008-11-24
1,646 reads
Friday I was up early for breakfast and check out of the hotel, then down to the convention center to...
2008-11-23
697 reads
Session evaluations are one real benefit that speakers derive from participating in community events - a chance to see how they...
2008-11-23
518 reads
I got back Friday afternoon from the PASS Summit and immediately was busy with family stuff. In fact, through Saturday...
2008-11-23
696 reads
I arrived home this morning after another PASS Summit. This is my 6th in a row. Each year I have...
2008-11-22
441 reads
I broke down and bought my first Vista machine last Sunday, an HP Pavilion from a local box store. From...
2008-11-21
612 reads
2008-11-20
746 reads
Shortly after I gave my presentation Trigger Happy Database Security down in Jacksonville for SQL Saturday #3, I received an...
2008-11-20
861 reads
I've been hanging around the SQL PASS Summit this week and came to a realization, I do know something...
I don't...
2008-11-20
448 reads
Went to the intro and keynote yesterday, even though I know better. They weren't bad, they just weren't great. I...
2008-11-20
668 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