ISQLME

A must have tool for working with the MSDE and MS SQL Server. Like Query Analyzer only easier to use. Designed to save you looking up syntax on the online books all the time. It has been crafted with a fine set of templates, shortcut keys and common tasks that make almost any SQL task a breeze.

Release Date: 1/3/2007
Release Status: Major Release

From a development perspective it is able to quickly script any database object. Useful for both creating new objects and checking the design of existing ones. After producing scripts ISQLME can format the query into Delphi code making the process even faster. It even includes some stripping procedures for turning coded SQL into straight SQL and even removing the #10, #13 and garbage delimiters in Delphi’s variable inspector.

From a support perspective you can track down database errors, inconsistencies (eg duplicate records, bad keys). You can also update data in an editable grid to save you writing SQL update statements.

How to: