Posted by Damian Mehers on 07/23/05 00:15

We have just released the first public beta of PromptSQL, a tool which adds
Intellisense-style help to Microsoft Query Analyzer.

You can watch a demo at http://www.promptsql.com/ and download the beta
without registration.

Press Ctrl-Space
.... after a word starting with '@' for a list of variables and parameters
.... after EXEC for a list of stored procedures.
.... in an SQL fragment that starts with EXEC <procedure name> for a list of
parameters
.... after ON for possible joins based on foreign keys in tables referenced
in a FROM
.....elsewhere in a FROM for a list of all table/view names
.... elsewhere in a SELECT for a list of columns from tables/views/aliases
used in the FROM, prefixed by the alias/name if necessary.

And of course press '.' after a table/view/alias name for a list of columns.

This is *not* a replacement to MS Query Analyzer -- it is a tool that
enhances the standard MS Query Analyzer.

Regards,
Damian Mehers PromptSQL.

[Back to original message]