SQL Server execute statement

• Parameters fit into one line

  EXEC Sptrackmember @p_member_id,'2.2',@p_weeknum 

• Stacked parameter

  • Comma at the end of line

  EXEC Sptrackmember @p_member_id,
       '2.2',
       @p_weeknum 

  • Comma at the begin of line

  EXEC Sptrackmember @p_member_id
       ,'2.2'
       ,@p_weeknum 

  • Comma at the begin of line, align parameters.

  EXEC Sptrackmember @p_member_id
      ,'2.2'
      ,@p_weeknum 

  • Comma at the begin of line, align parameters, space between comma and variable from 1 to n

  EXEC  Sptrackmember @p_member_id
      , '2.2'
      , @p_weeknum