Wednesday, October 25, 2006

 

SQL Developers: Download SQLPrompt

RedGate, the providers of several completely excellent SQL Server-related software products, have a free download called SQLPrompt.
Very well-done, intellisense for your SQL Server connection. Works in Query Analyzer, VS.Net, SSMS.

An example of its robustness: having typed "FROM myTable INNER JOIN ", I'll automatically get a list of tables with foreign keys referencing myTable, or with primary keys that myTable references. Having selected one, then continuing to the ON phrase of my join, SQLPrompt will offer the right expression to complete the join.

If you go into the advanced options you'll find such goodies as "automatically change keywords to uppercase as I type."

It gets annoying some times when the software becomes a little confused, but not too often, and then I'll just reach down to the system tray and turn it off.

/T

Comments:
Great tool Tyler... thanks for the tip!
 
Thank you for the info. It sounds pretty user friendly. I guess I’ll pick one up for fun. thank u


ASC Coding
 
Great post, thanks!
What about SQL Complete https://www.devart.com/dbforge/sql/sqlcomplete/productivity-extension.html ?
This tool takes care of building, editing, and modifying SQL queries, managing and analyzing SQL code, thus making the process more efficient and as simple as ABC.
 
Post a Comment



<< Home

This page is powered by Blogger. Isn't yours?