Your's example code:

It's better to use statements like :

  if @parameter is null ....

SP parameters can be obtained from metadirectory

Uneeded and espesially not current comments are wost then none!!!