O, There’s the Data: Using OData in SSIS
The Open Data Protocol (OData) is an open specification created Microsoft to enable exposing data in a standard way from...
2012-07-23
1,288 reads
The Open Data Protocol (OData) is an open specification created Microsoft to enable exposing data in a standard way from...
2012-07-23
1,288 reads
As noted in that great text, The Hitchhiker’s Guide to the Galaxy, “Don’t panic!” Excel 2013 will make even more...
2012-07-17
823 reads
This will be the easiest entry in this series. This is a reblog of an article I wrote last year....
2012-06-26
1,185 reads
I am pleased to announce that I will be speaking at the PASS Summit again after a four-year “break”. I...
2012-06-22
526 reads
The fourth segment in this series focuses on using XMLA to deploy databases. When you create SQL Server Analysis Services...
2012-06-19
910 reads
Reblogged from Data on Wheels - Steve Hughes: As I was working through some issues with my cube design, I realized...
2012-06-17
1,082 reads
When in Portland… This week I am in Portland, Oregon working with a customer. While I was here, I thought...
2012-06-07
617 reads
When working with Oracle, drivers are truly a pain to get working correctly. I will discuss my preferred choice and...
2012-04-24
923 reads
Minnesota SQL Server User Group Meeting Review (4/17/12) First of all, I have to thank the awesome speakers who presented...
2012-04-19
571 reads
While attending a recent Windows Azure Quick Start, the presenter, Mike Benkovich (@mbenko) happened to show a table on his...
2012-04-17
598 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