Have you ever worked with code that is impossible to read and decipher? You could use SQL Prompt which will format the code into a readable format, however what if there is so much going on you are still unable to decipher what is happening?
Recently I came across this problem where a function was doing so many things I couldn’t tell where it started and where it ended. There is an amazing tool that was super helpful, it is the T-SQL Source Code Unscrambler that is offered by GenesisOne.
This was a lifesaver for me, saving many hours of trying to figure out code. This tool allows you to connect to your SQL Server database and view any tables, views, stored procedures and functions.
This tool allowed me to select the function that was a mess and in the diagram view I could see what the function was trying to do. It shows if there are conditions, variables and the flow of the function.
This tool is also brilliant for doing technical documentation with diagrams of the systems and data flow in stored procedures and functions.
Below are a few screen shots of the different views and information this tool provides:
Stored Procedure View:
Graphical View of Dependencies:
How to Export:
For a full list of all the amazing features that comes with this application, click here.