SQL Prompt - Intellisense for SQL
Posted on July 26th, 2006 by Tim Almond
Redgate have released SQL Prompt, which gives Intellisense to SQL Server.
Get it from here and give it a whirl. It’s not time or feature limited.
A day of use, and I don’t think I can live without it.
RSS
I am puzzled. What do you write these scripts for?
I was of the incorrect belief that most handwritten SQL code is embedded in other languages.
Even the CREATE TABLE commands in my latest database are embedded, though auto-completion would not help much for CREATE TABLE.
Don’t get me wrong - I think auto-completion is a great thing. I just think it would be much more useful in a programming IDE.
David,
The development model that I favour in the stack of IIS/ASP.NET/C#/SQL Server is to wrap my SQL tightly within SQL Stored Procedures, and that the C# code calls those stored procedures to interact with the database.
So, there’s almost no SQL embedded in the C# code.
When I’ve met other developers using the same stack, they do the same thing too.
This stuff is also useful for odd bits of 1-off maintenance that don’t really need a program, but just a few queries in query analyser.
Tim