Code that is impossible to read and decipher....
Anthony Gallo
President/Co-Founder Vision Genesis, Inc., in Navy SBIR Contract Partnership with TCG, Inc.
GenesisOne? T-SQL Source Code Unscrambler?
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 link displays several screen shots of the different views and information this tool provides:
https://thesqlgirl.com/2017/01/04/genesisone-t-sql-source-code-unscrambler/
How to Export:
For a full list of all the amazing features that comes with this application, click here.
If you would like a free fully functional trial of the Unscrambler, please contact us at. [email protected]
www.GenesisOneSolutions.com/home
IBM Technical Validated Partners
Owner/Craftsman at Shaker and Colonial Furnishings
7 年cool tool. doesn't address much of the stupidity I had to deal worth in bash or perl programmers back in ibm, but that is pretty slick for sql
President/Co-Founder Vision Genesis, Inc., in Navy SBIR Contract Partnership with TCG, Inc.
7 年Thank you Antonio, that has now been corrected....just click on the link within the post.
Product Management - Data Management, Data Access Governance
8 年Screen shots didn't appear on lInkedin