I agree, the result is correct but the explanation is wrong. And this is a good example why you should never omit any default statements even it may be tempting for lazy programmers. 😀
Oleg Netchaev (10/2/2010)
This is a good basic question, but the part of explanation is totally wrong. I am referring to this:
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform