at first i thought it was an error in the downloaded chapter examples, but now i see it is because of the 'intellisense' in the SQLQuery window. the sections of sql code that have collapsible portions... the little minus sign that seems to indicate the end of the collapsible section....?
my question is how does intellisense decide when to create a collapsible section and when not to?
i notice in the Chap03.sql code, that some of the Select statements are collapsible and some aren't, some are included as a group of Select statements in a collapsible section and some are on their own. some Select statements end in a semi-colon and some do not.
can how intellisense works be explained? maybe add a chapter just on it?
for example, can it be configured to upper case automatically the reserved words? it knows they are reserved because it colors them blue, so it should be able to uppercase them as i type also.