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.
Keywords: formatter, beautifier, indenter, source code, t-sql, transact sql
|
Click to enlarge
|
|