Intellisense and objects created on the fly
I had an email from one the people that attends the
usergroup I help run in London. She was suprised that when she had a create
table statement intellisense is able to understand that this table is
being created and provide intellisense on that table. This is just like any
other object in your script, i.e. if you declare a variable then intellisense
can provide that variable in a list for you. I guess tables are more
complex than variables, but if with other languages like C# the intellisense is
able to parse objects methods and even comments to provide information about
those objects and methods without even compiling your code.
For a demo of this feature have a look at this nugget http://media.sqlknowhow.com/nuggets/Intellisense%20and%20objects%20created%20in%20scripts.wmv
-