Someone may think this is a feature, but i think it is sad that SQL doesnt handle this as an error due to the fact that it is to easy skip optional parameters/statements, and some people does not have the fully understanding of why it is sometime very important. This laziness may lead to bugs.

My recommendation is to never skip optional parameters or statements. It tends to be more code to write, but it is more secure.

/Håkan Winther

Senior Development DBA