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.

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)

About these ads

15 thoughts on “SQL SERVER – Right Aligning Numerics in SQL Server Management Studio (SSMS)

  1. 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.

  2. 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

  3. 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.

  4. Pingback: SQL SERVER – Remove Debug Button in SSMS – SQL in Sixty Seconds #020 – Video « SQL Server Journey with SQL Authority

  5. Pingback: SQL SERVER – Weekly Series – Memory Lane – #022 | SQL Server Journey with SQL Authority

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s