Tidycode T Sql Formatter

SQL is a programming language that was originally designed by IBM computers for operations on relational databases with the use of declarative statements. An expansion over the standard SQL, named as T-SQL was developed with the inclusion of local variables, procedural programming, date and string processing among other functions. T-SQL has useful application in the modern programs developed on Microsoft SQL platform, and the code is highly prone to errors related to syntax and formatting. Tidycode T Sql Formatter v.1.1 has been developed as an efficient and user friendly solution for such problems along with some of the powerful features that makes the T-SQL code related tasks simpler.

Tidycode T Sql Formatter is a software tool that helps the user in tidying up and formatting the T-SQL code in a DOS prompt or batch file. This is basically a command line tool that can be easily integrated in your programming environment and in many IDEs (Integrated Development Environments) and editors which may be for freeware or commercial usage. The program supports formatting of the SQL code itself and has easy to use functionality for batch processing and backing up of files. After the formatting of source is completed, the program can export the output to clipboard and can also retrieve source from the same. The built-in formatter inside the program can quickly make out even the smallest syntax errors and has features for displaying error results in a user friendly manner. Among the host of options that make this program extensively versatile, there is a powerful feature of converting the source into HTML.

To sum up, Tidycode T Sql Formatter v.1.1 is a nice program with a primary usage of sorting out any syntax errors in the SQL code and packs other features that make the daily task of users simpler. Hence it receives a decent score of four rating points out of five.

This software allows you to tidy, beautify or format your T-Sql code in a batch file or Dos prompt.
In other words, it is a command line tool that can be built in your programming environment. It can be used in most free or commercial editors/IDEs. Especially if they support reloading the source in the editor.
It has more than 90 options. It supports batch processing of files. It can back up files. Formatting Sql in itself is also supported. The software can output the formatted source to the clipboard. It can also accept a source through the clipboard.
The formatter can be useful to find syntax errors too as it detects and displays syntax error in a user friendly way.
When there is a syntax error in the code , it shows "block stack" - the location of error in the code relatively to the enclosing if/while/begin blocks.
There is a switch that adds information about the current block at the end of the block as a comment.
It can convert the source into HTML as well. There are many other options which make the program more versatile.
The software package also contains a tool Experimenter which provides an alternative user interface to the formatter. In this way, the command line switches of the formatter can be tried out/determined quickly and easily.
There is a third tool included too:Tool Installer for easy installation.