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 (http://blog.sqlauthority.com)
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 !!
[...] SQL SERVER – Right Aligning Numerics in SQL Server Management Studio (SSMS) [...]
this is only for Results to Text. what about Result to Grid, which is much more standard ?
This is not possible in Grid mode
[...] Right Aligning Numerics in SQL Server Management Studio (SSMS) SQL Server Management Studio is my most favorite tool and the comfort it provides for users 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 easy to read the digits as we are used to read the numbers which are right aligned. [...]