Countdown to PASS Summit 2012 – 8 to Go – What Is PASS Anyway?
Eight days to go. So after going to my first conference, I was surprised that I did not know more...
2012-10-29
1,213 reads
Eight days to go. So after going to my first conference, I was surprised that I did not know more...
2012-10-29
1,213 reads
We are less than ten days to the start of PASS Summit 2012. I thought it would be fun to...
2012-10-28
592 reads
Over the past few years, I have used Windows Live Writer to create my blog entries on WordPress. Given the...
2012-10-26
2,792 reads
In the 7th article of this series, I will discuss how to manage your partitions with XMLA. We will be...
2012-10-10
646 reads
I recently completed a series of blog posts on www.lessthandot.com on T-SQL Window functions. The enhancements to SQL Server 2012...
2012-09-26
902 reads
In this post, I will progressively go through processing a partition from full process, to incremental process, and finally to...
2012-09-19
807 reads
We are less than two weeks away from SQL Saturday #149 in Minneapolis on September 29, 2012 with two preconference...
2012-09-18
529 reads
First, I need to set the record straight – I am not a systems guy. When I need work done to...
2012-08-30
1,367 reads
When Jason ( B | T ) posted this assignment, I thought it would be a fun topic to write on. Before I...
2012-08-15
513 reads
As I started looking over my event calendar, I was amazed at how many events Magenic is sponsoring, hosting or...
2012-08-14
566 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