Dan English's BI Blog

Welcome to my random thoughts in regards to Business Intelligence, databases, and other technologies

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
sql_intell_delete sql_intell_insert sql_intell_update

 

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
sqlprompt1

 

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
sql_query_tab sql_query_tab_2005
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: