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.
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.
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.
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)
16 Comments. Leave new
It looks good, thanks for sharing
nice tip.. thanks.
Simply superb. Thanks for sharing
Hi Pinal sir,
I am thinking of this type of feature from last tow days and here it is.
Thank$
Chirag Satasiya
Recently I was retrieving numeric data in SSMS and I found it is very difficult to read them as they were all right aligned.
In the article above ,I guess this is a small mistake it should be left aligned intead of right aligned.
Not working in Result In Grid
its nor working
great job man!!!!
Nice tip Pinal, I think this feature would work only on Results to Text, in Grid i think results are in a tabular format within a grid.
Thank you
Nice Tip Pinal, i feel that this option works with query output set to Results to Text. In case of grid the data is in a tabular format which can be adjustable.
Good One Pinal !!
this is only for Results to Text. what about Result to Grid, which is much more standard ?
This is not possible in Grid mode
WILL THIS CHANGE BE REFLECTED IN THE FRONT END PART LIKE GRID VIEW CONTROL..???
It did not work for me in SQL 2014. The column types are tinyint and int. I set the Query Options properties exactly as you did. But all those numbers still align to the left ugly.
hi Pinal, can you please tell Microsoft that even McSQL’s Heidi SQL right aligns numbers in the grid!