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!
 
norwegion cruise lines
 
Hello!
http://consolidate-debts.blogspot.com/
Good Luck!
 
More Info!

http://poker-ph78t.blogspot.com/
Good Luck!
 
Thank you for the info. It sounds pretty user friendly. I guess I’ll pick one up for fun. thank u


ASC Coding
 
Post a Comment



<< Home

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