"Share" gadget big Smart SQL Execution Tool

Tools overview

This is the case, before our company has a lot of SQL used to complete some very humble but have to complete the business, out of convenience directly in the SQL Query Analyzer execution, supposedly should write some special tools, but these scripts are many, so I wrote a small tool, As long as the SQL can solve the problem can be used to it, then what is the advantage of it?

First, the previously written SQL can not be changed, just need to extract the parameters in accordance with the specification of a template can be changed, using the tool to load the template, the tool will automatically provide the parameters required by the module to fill the user.

Second, the template file can be configured with a good connection string, so that you do not have to connect to the database every time, but also to avoid the connection error situation, do not understand the SQL users can also use.

Third, there is the same table as SQL Query Analyzer, also supports a number of yo.

Here is the interface:

Templates

SOURCE download

The implementation is relatively simple, the code can explain the problem, take it!

Address