SQL Prompt - IntelliSense for SQL Server
I just started using the new SQL Prompt 3.6 from Red Gate today in ernest and I am wondering why I waited so long. This product is amazing! It provides IntelliSense for SQL Server. I am using it inside the SQL Server Management Studio 2005 but it works with Microsoft Query Analyzer, SQL Server 2005 Management Studio, Visual Studio 2005, Visual Studio .NET 2003, SQL Server 2000 Enterprise Manager, UltraEdit32. It had me at the SQL keywords but I really felt compelled to write this post when I faced having to type a lengthy insert and I typed "IN" and got: USE [gregs_list]; INSERT INTO [my_contacts] ( [last_name], [first_name], [email], [gender], [birthday], [profession], [location], [status], [interests], [seeking]
/* last_name - VARCHAR(30) */ '',
/* first_name - VARCHAR(20) */ '',
/* email - VARCHAR(50) */ '',
/* gender - CHAR(1) */ '',
/* birthday - DATETIME */ '2007-10-24 1:11:34.414',
/* profession - VARCHAR(50) */ '',
/* location - VARCHAR(50) */ '',
/* status - VARCHAR(20) */ '',
/* interests - VARCHAR(100) */ '',
/* seeking - VARCHAR(100) */ '' )
Yah baby! Its reading the database schema and gave not only the columns but what the datatypes were! This one is a keeper!
