Formatting SQL Procedures


Have you ever opened a standard GP stored procedure?

I do it at least on a weekly basis and have always found it impossible to read as it is. So I end up aligning the procedure first and then read it to understand the logic.

Not anymore. David has shared information on some portals which does this in seconds and give us an aligned code.

Standing out from his list is Poor SQL, from what I learned from my usage.

And there is a plugin for SSMS which does this from within SSMS. This tool is called SSMS Tools Pack.

Happy aligning.

VAIDY

Advertisements

4 thoughts on “Formatting SQL Procedures

  1. The SSMS Tools Pack is just awesome… Especially a couple of tools which I loved was to search through query results in grid layout and the option to generate insert statements for table data, and the insert statements are created in batches, which is even better…
    Great find!

    Like

  2. Vaidy, did you remember how many times we have formatted the stored procedures manually, right? This tool will really save our big time. Thank you very much for sharing this info.

    Like

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