Free until September 1st!
If you spend any significant amount of time coding SQL, you'll want to check out Red-Gate's SQL Prompt.
This product makes it very easy to write SQL by providing Intellisense-like functionality found in Visual Studio. You are automatically provided with lists of tables, functions, variables. Once you start using it, you'll wish you always had it. It is very customizable, and provides snippets functionality as well. You have to download and try it to see how useful it really is.
Since ListRing is such a data intensive application, it's a no brainer that I'll be making a lot of use of SQL Prompt going forward.
Best of all: it's FREE! but only until September 1st.
http://www.red-gate.com/products/SQL_Prompt/index.htm
Red-Gate designs some of the best UIs I've ever seen. Their applications are extremely intuitive. You'll want to check out their other great tools such as SQL Compare.
