Bug: Smallmoney in SQL Server shows too many decimal places

[tstrilch]

Describe the bug

Ever since one of my recent upgrades I noticed that smallmoney values in SQL Server are showing extra decimal places. The previous version showed the precise amount to two decimal places, but the new version shows extra digits that aren't there (when downloading results as CSV they show up properly). I've even done a subsequent upgrade to the latest version and it's still persisting. I use an M1 Mac mini (MacOS Tahoe 26.3.1)

Here is a simple way to reproduce (using SQL Server 2017):

---

create table tmpMoneyTest
(
ID int IDENTITY(1,1),
Amount smallmoney,
Amount2 money
)

insert into tmpMoneyTest(Amount,Amount2) values (1.00,1.00),(2.00,2.00),(3.00,3.00)

insert into tmpMoneyTest(Amount,Amount2) values (1.07,1.07),(2.52,2.52),(3.88,3.88)

select * from tmpMoneyTest

---

I've included a money column as well to show expected behaviour.

I've attached a screenshot using my example above.

Product

SQLPro Studio

App version

2026.07 (Build 111167.5)

Platform

macOS

Installation source

Website download

[hankinsoft]

Hi,
If you get the chance could you test build:
https://sqlprostudio.s3.us-east-1.amazonaws.com/mssql/SQLProMSSQL.2026.25.app.zip

It should sort both this issue and the importing here.

Please give it a try and let me know if that helps out.

Cheers!

[tstrilch]

Do you have a version of SQLPro Studio I can try?

[hankinsoft]

I'm away for the moment but I can post one tomorrow. Sorry for the inconvenience, it's generally quicker for me to build the one off product so I tend to do that for bug tests. But I will post Studio first thing.

[tstrilch]

No worries... I'm just happy that it's getting some attention. Let me know whenever it's ready and I'll be glad to test.

One other small bug I noticed in the latest version - the Results pane at the bottom of the screen used to always adjust the column widths based on the contents of each column. In the latest version it randomly makes all columns fixed width (and very wide). I just tried a sample where I queried a limited set of columns and then another query where I added * to the end (i.e. select a,b,c vs. select a,b,c,*). I've attached the screenshots below. When I added the * all of the columns became fixed width and are so wide, that you can't view much of the data without scrolling.

[hankinsoft]

Hi,
The SQLPro Studio build is available here:
https://sqlprostudio.s3.us-east-1.amazonaws.com/studio/SQLProStudio.2026.26.app.zip.

For column width's I would suggest opening a new issue. This is something I seem to be revising fairly often (I'm quite sure the recent changes were due to another users preferences) so it might be something I need to add some preferences for.