MS SQL Code Factory is a leading MS SQL Server GUI utility designed to build SQL queries and develop scripts.

The application also provides you with a powerful set of tools to edit and execute SQL scripts, build visual diagrams for numeric data, customize user interface according to your needs and much more.

Here are some key features of "MS SQL Code Factory":

· Optimum price/quality ratio
MS SQL Code Factory is a good choice for everyone who need build SQL statements and edit SQL scripts with a convenient easy-to-use interface

· Clear in use
Even a newbie can use MS SQL Code Factory

· Code folding, syntax highlighting, and code completion
Working with queries and scripts becomes easy

· Simultaneous executing of several queries
Multi-threaded query execution is implemented

· Latest MS SQL Server versions support
MS SQL Code Factory supports all the latest versions of MS SQL Server

· Advanced data management
Viewing, editing, sorting, grouping, and filtering of the result data management

· Visual Query Builder
MS SQL Code Factory allows you to create the SELECT statements visually

· Full support for BLOB fields
MS SQL Code Factory has an ability to view/edit BLOB data in various ways

· Viewing data as diagrams
MS SQL Code Factory allows you to build diagrams based on MS SQL Server data

· Full customization according to your preferences and needs
MS SQL Code Factory admits to flexible customization


Requirements:

· Pentium 166 MHz
· 64MB RAM
· 10MB HDD
· SVGA
· Internet Explorer 4+


Limitations:

· 30 days trial

What's New in This Release: [ read full changelog ]

· The SQL Formatter for DML statements (SELECT, INSERT, UPDATE and DELETE) is implemented. It can be invoked by means of the Format SQL link on the SQL Editor's navigation bar (Ctrl Alt D shortcut).
· The SQL Generator tool has been implemented. Use this feature to produce various SQL scripts (CREATE, DROP, SELECT, INSERT, etc) for the selected object. The result script can be saved to a file, copied to clipboard, and opened in SQL Editor or SQL Script Editor.
· Some new features have been incorporated into SQL Editor and SQL Script Editor. Now it is possible:
· comment/uncomment selected text (Shift Ctrl . / Shift Ctrl , shortcuts respectively). If no text is selected, the whole line will be commented. By the way, it is not necessary to select commented text to uncomment it, just press Shift Ctrl , having the cursor inside the commented text. Both kinds of comments (single-line and multi-line) are supported;
· convert selected text to different cases (lower, UPPER, and NameCase);
· export the contents of the editor to RTF and HTML formats (to file or to clipboard);
· create a new query, close existing one, save the query to profile, etc. using a popup menu that has been added to each query tab;
· print/preview the contents of the editor;
· use the script runner to execute large scripts without opening them in the editor window.
· Data Grid has been significantly updated:
· Starting with this version it is possible to use the lookup editor for a column, which is linked by a foreign key with a (single) column from another table. The editor displays the contents of parent table’s columns within the dropdown window.
· Now the grid automatically switches to the Simple mode for queries that return more than 5000 records (the number can be customized in the Options dialog). This mode allows you to get thousands and millions of records displayed in a few seconds, but does not feature filtering, grouping and sorting abilities.
· Now it is possible to encrypt the contents of the selected cell by the md5 algorithm (the corresponding item has been added to grid's popup menu).