Every now and again I run into a tool which is just amazingly stunning. Today I looked at the SeeSharp.nl blog and found an excellent tool called SQL Prompt by a company called Red Gate.

It is a free tool and definately worth the download if you write even one SQL statement per week!

Features include:

• Code completion for fast, accurate script building
• Discoverability in SQL Server query creation
• Keyword formatting, code snippet integration other extended features
• FREE until 1st September 2006
• No time-bombs, no restrictions
• Table/View name completion
• Column name completion
• Stored procedure name completion
• USE completion
• JOIN/JOIN ON completion
• Auto-uppercasing of keywords
• Auto-popup after keywords