The important point with this question is that you should never take anything for granted and always specify "optional" paramters/statements
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform