|
|
Posted by Damian Mehers on 09/27/73 11:23
We've added T-SQL Intellisense-like word-completion support for Visual
Studio 2003/2005 and the SQL Server 2005 Management Studio to our PromptSQL
product. So you can now have auto-completion for TSQL in those environments
and of course Query Analyzer.
SELECT * FROM Em[Ctrl-Space] displays a popup with all tables starting with
Em
SELECT * FROM Employees AS e JOIN [Ctrl-Space] shows a popup with all tables
related to the employees table (via primary/foreign keys)
SELECT * FROM Employees AS E JOIN Orders o on [Ctrl-Space] shows a popup
with possible joins based on primary/foreign keys on the tables in the FROM.
Press "." after a table name to get the columns in the table. It has proper
support for SQL Server 2005, which of course means prefixing table names
with schema names as appropriate.
Online demos and registration-free download: http://www.promptsql.com/
PromptSQL is written in C# and uses hooks to monitor Query Analyzer and the
other supported environments. You carry on using these standard tools.
Regards,
PromptSQL Team.
"Damian Mehers" <feedback at promptsql.com> wrote in message news:...
> 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.
>
>
>
Navigation:
[Reply to this message]
|