SQL SERVER – Right Aligning Numerics in SQL Server Management Studio (SSMS)

SQL Server Management Studio is my most favorite tool and the comfort it provides to user is sometime very amazing. Recently I was retrieving numeric data in SSMS and I found it is very difficult to read them as they were all right aligned. Please pay attention to following image, you will notice that it is not easier to read the digits as we are used to read the numbers which are right aligned.

SQL SERVER - Right Aligning Numerics in SQL Server Management Studio (SSMS) aligncol1

I immediately thought before I go for any other tricks I should check the query properties. I right clicked on query properties and I found following option. I checked option Right align numeric values and it just worked fine.

SQL SERVER - Right Aligning Numerics in SQL Server Management Studio (SSMS) aligncol2

Do you have any other similar tricks which do you practice often. I prefer to also include column headers in the result set as it gives me proper perspective of which column I have selected.

SQL SERVER - Right Aligning Numerics in SQL Server Management Studio (SSMS) aligncol3

Sometime little tips like this helps a lot in productivity, I encourage you to share your tips. I will publish it with due credit.

Reference: Pinal Dave (https://blog.sqlauthority.com)

Solarwinds
Previous Post
SQL SERVER – Partition Parallelism Support in expressor 3.6
Next Post
SQL SERVER – T-SQL Constructs – *= and += – SQL in Sixty Seconds #009 – Video

Related Posts

16 Comments. Leave new

Leave a Reply

Menu