Code Insight?

Hello

Is there any plans to implement Code Insight in to SQL Server 2008?

Thx

What do you mean by Code Insight ?

Jens K. Suessmeyer.

http://www.sqlserver2008.de
|||IIRC Code Insight is borlands name for Intellisense (and a bunch more stuff)|||

Euan Garden wrote:

IIRC Code Insight is borlands name for Intellisense (and a bunch more stuff)

Yes, Intellisense is what I have i mind. Thx

I think this is one of the most wanted feature.

|||

Definitely. I think SSMS was a huge improvement over Enterprise Manager and Query Analyzer, still i tend using ApexSQL Edit instead, and there are two reasons:

Code Completion (Intellisense)

Code Snipplets (lets you actually lookup data in the database when you use it)

You do know that Intellisense were present in one of the really early betas in SQL Server 2005?

|||

Jasmin,

Can you describe the areas you'd like to see Intellisense. For example, in the FROM clause you could get a dropdown list of databases, selecting a DB and hitting ".", would list the schemas in the database, etc.

Thanks,

Dan

|||

I'm hooking on to this one.

When you type FROM <space> you should have a list containing:

A) Schemas defined in the sql script file

B) Selectable objects (tables, views, ctes, synonyms and functions returning record set) from script file

C) Schemas defined in the database in the current database

D) Selectable objects (tables, views, ctes, synonyms and functions returning record set) from the current database

E) The name of any database from which you can select.

As you type, objects not matching the typed text should be removed.

WHEN you go back to select columns, you should see:

A) All columns available from all sources in the from clause

B) All common functions

C) All user-defined functions from the script file

D) All user-defined functions from the current database context

This sounds very heavy, but keep in mind... The information may be cached in the app...

|||

We are planning to support Intellisense in the next release of SQL Server code named "Katmai". A CTP to be released this fall should have this feature enabled in SQL Server Management Studio.

Thanks,

- Balaji Rathakrishnan

Microsoft SQL Server

|||That's good news Balaji. Thanks a lot.|||

I think Ole Kristian Bangaas has write nice post about intellisense feature.

I have just one add on it. It would be nice when you write FROM clause, DB engine should "look" in to USE part and give list of schemas, tables..etc.

But when we chose an object and hit enter, cursor should "jump" line above and automaticli write SELECT..and rest of job is on us. And yes, it shuld be fast like in Visual Studio, everything else is waisting a time.

|||

Just feedback about the problems we have with current products that offer intellisense for SQL:

Need to enable it or disable it easily. Very long scripts (i.e. scripting an entire db) make all Intellisense product go buts, slow and un-useful. When switching between multiple large db, it becomes dreadful (trying to load the schema of a db with thousands of objects can't be anything else than long). Scripts that refer to multiple dbs are also a problem (server.db.schema.name). Being able to limit the tool to tables/views, etc. could be useful. If I am working on the schema I don't want it to load, parse and understand all dependancies in stored procedures. That could give a nice speed boost. Products usually go nuts with complex scripts (lots of corrolated sub-queries, CTE, etc.). Two things that would help are: recommend users to terminated statements with ';' to help the parser. This is a good practice anyway now because it is required in some cases (CTEs) provide a visual cue as to was the "current statement" is. Any typo can make the parser behave differently. I know VS does this already but SSMS does not (and VS is NOT a dba tool. I use VS for C# work and will always use SSMS for dba work).|||

Mirror PL/SQL Developer by AllRound Automations. It's lightweight and works great; even formats

Don't mirror the Red Gate tool SQL Prompt, even the new version is one of the worst products for intellisense. It's clugy and uses too many resources.