Suggestion: Context Sensitive Intelligence

SQL Assistance is my second favorite tool after Visual Studio.NET. To make it more intelligent, I would like to suggest SoftTree to make SQL Assistance CONTEXT SENSITVE INTELLIGENT like VISUAL STUDIO EDITOR. Current ver 4.8 is not intelligent enough although it provides great number of feature which every DB developer needs day-to-day. You may refer all my posts to get what I really mean by context sensitive intelligent. I hope you are working on it to make it world class DB tool.

Hitesh Davey

Hi,

I'd like to assure you that we working very hard on improving the "intelligent" part as well as adding other important features developers and DBAs need on a daily basis.

However, it is a great mistake to expect and compare SQL Intellisense to VS Intellisense for compiled languages. The single most important reason, VS Intellisense is based on the code compiled and "understood" by the compiler, which at that time knows all the details and all the dependencies, and generates special "browse" files for the VS IDE. VS Intellisense relies on these specially compiled browse files. If you have noticed, Intellisense in a VS project is not available until you build it at least once. In comparison, the SQL "text" processed by SQL Assistant is not compiled. It is a text, not a compiled code. Indeed, when executed, it is compiled on-the-fly by the database engine, and only the database engine knows all the dependencies and "understands" the meaning of the code. I want to make a point, that SQL Intellisense can never be matched against compiled language Intellisense, such as that available in VS; it has a different nature and a different purpose. In fact, if you want to see Microsoft version of SQL Intellisense, check SQL Server Management Studio 2008. I'm sure you will be disappointed. Note that SQL Server Management Studio is an off-shot of Visual Studio IDE.

We expect many new significant features in the next major version, including improved code parsing and Intellisense, more coding automation, advanced multi-database code and schema refactoring, and many others.

Best regards,
SysOp