SQL Promot provides intellisense inside your Query Designer in SQL Server and helps you show the entire database schema including table names and their column names. If you are Visual Studio 2005 Intellisense a lot (who doesn't), you may want to try SQL Prompt ASAP and I am sure you will love it.
I write lot of SPs and SQL queries and this tool has saved me ton of time.
Click here to download a free version
and don't forget to share what you think of it.
Mahesh ChandPosted Nov 20, 2007, 7:50 AM
Thanks for your feedback MI. I will let RedGate folks know about it.
Muktheshwar IllendhulaPosted Nov 16, 2007, 4:38 AM
Hi, I worked on SqlPromt 2006 version, in 2006 version, it doesnt supports intellisense for all the SqlObjects and it supports intellisense only for Tables and Columns.It doesnt support intellisense for StoredProcs, Indexes, Cursors. Major Issue: we were able to get intellisense for tables and columns, but when we are writing storedprocs most of the scenarios we will be using alias, when we use aliases for table names we are loosing intellisense. That means it supports straight forward intellisense. Ex: Working Scenario --> Select * from Employee Where Employee.EmpId = 100 [ Intellisense is found when go for Employee. ( here i found all the columns of the employee table) ] Nonworking scenario --> Select * from Employee emp Where emp.EmpId = 100 [ Intellisense is not found when go for emp. ( here i didnt find the columns of employee table) ] Let me know if this feature is available in 2007 version of SqlPrompt... Thanks.
Muktheshwar IllendhulaPosted Nov 16, 2007, 4:26 AM
asda