X on XMLA: iii. Basic DDL Functions in XMLA (Create, Alter, Delete)
XMLA can be used to manage the structure of your multidimensional databases. While many developers use Visual Studio (BIDS), to...
2012-04-10
723 reads
XMLA can be used to manage the structure of your multidimensional databases. While many developers use Visual Studio (BIDS), to...
2012-04-10
723 reads
If you happen to be in the area on April 21, 2012, join us at Madison Area Technical College – Truax...
2012-04-04
603 reads
The first tip I published discussed how to execute an Oracle procedure with no parameters. In this tip, I will...
2012-04-03
744 reads
Earlier this month I published a blog entry on this same subject. In honor of the local Minneapolis launch event,...
2012-03-28
704 reads
The second post in the XMLA series focuses on the basic structure of XMLA. At its heart, XMLA is XML. ...
2012-03-27
704 reads
I just wanted to plug two events that are free SQL Server training. First, Thomas LaRock (@sqlrockstar) and Jason Strate...
2012-03-20
589 reads
By now many of you have had the opportunity to hear or see something about the next release of SQL...
2012-03-08
677 reads
Originally posted: 3-4-2012 Welcome to a new blog series of tips related to Oracle with a focus on helping those...
2012-03-04
596 reads
As many of you may know, I am the Chair for the Minnesota SQL Server User Group aka PASSMN. I...
2012-02-22
595 reads
This past Tuesday, February 14, I was invited to discuss how technology can be used to help analyze data for...
2012-02-16
608 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