Dynamic SQL Generator

Dynamic SQL Generator is a lightweight utility designed to help you generate dynamic T-SQL scripts and vice versa with just one click.

Following a quick and uneventful installation, you are welcomed by an instructions page that provides you with a summary of the functionality of the application. You can add SQL files for any desired modifications by accessing the T-SQL Script tab. It is worth mentioning that while you either enter the T-SQL script or drag and drop the SQL files.

The working space is designed with a white, clean background, an option that enables you to view your code clearer, particularly if you decide to access the Apply Basic Syntax Highlight formatting option.

The other available options that allow you to examine your code more minutely include uppercase, lowercase and word wrap. Although you can find them in the formatting section in the lower section, it would have been useful if they were slightly more visible.

Functionality-wise, the application is as simple as it gets and entails loading the desired SQL file and afterwards, generating the static or dynamic T-SQL code. You will be happy to learn that you can restore the modifications made via the Restore Original T-SQL function.

While the program's primary function is to generate T-SQL scripts, you will be happy to learn that you can also examine the code and correct potential mistakes just as easily. Moreover, if you are working with T-SQL files, you can export the new script to a new SQL file format. You can also copy the modifications to clipboard in case you intend to use them with other applications.

Regardless of whether you are interested in trying out the new error handling capabilities of the T-SQL scripts or you solely need to edit an SQL file and update your database application, Dynamic SQL Generator could come in handy.