SQL Server 2008 (RC0) Intellisense Enhancements
Posted by denglishbi on June 12, 2008
I looked into a few items in regards to intellisense with the new release to follow-up on my previous two postings SQL Server 2008 Intellisense (CTP5) vs Red Gate SQL Prompt and
SQL Server Intellisense (CTP6) vs Red Gate SQL Prompt – Part II. The only things that I could see that have really changed was some additional support for DELETE, INSERT, and UPDATE statements and some additional metadata (which is great).
|DELETE Screenshot||INSERT Screenshot||UPDATE Screenshot|
You can also see in the screenshots that some metadata information is being displayed too, I don’t believe this was in CTP6, but I could be mistaken. So now when you are on an item in the drop down list it shows the object type and data type information if it is a column. That is nice, not quite as nice as the metadata information provided with SQL Prompt, but I guess they can’t take all of Red-Gate’s ideas.
|Red-Gate SQL Prompt Intellisense|
I didn’t really see any other changes other than the additional support and some metadata information but these are all good changes. I did notice that the metadata in the query window tab changed a bit now, so you can see some additional connection information (user and spid) for the query window.
|SQL 2008 RC0 Query Tab||SQL 2005 Query Tab|