SQL Server execute statement

• First parameter in newline

  Option: fmt169_mssql_execute_parameters_in_newline = true, type: TFmtBoolean.

  Option: fmt170_mssql_execute_parameters_indent = n, type: TFmtInt.

  EXEC Sptrackmember 
    @p_member_id,'2.2',@p_weeknum 

• Align value of parameter

  Option: fmt177_mssql_execute_parameters_align_value = true, type: TFmtBoolean.

    EXEC Spr_store_note 
      @NoteId      = 0, 
      @TableTypeId = @TABLE_CUSTOMER,
      @RecordId    = @CustomerId

• Parameters fit into one line

  Option: fmt168_mssql_execute_parameters_style = fit_into_one_line, type: TFmtListStyle.

  EXEC Sptrackmember @p_member_id,'2.2',@p_weeknum 

• Stacked parameter

  Option: fmt168_mssql_execute_parameters_style = stacked, type: TFmtListStyle.

  • 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

    > *Option:*  **fmt171_mssql_execute_parameters_comma_option** = **before_item_outside_list_with_n_space**, type: **TFmtCommaOption**.
    
    > *Option:*  **fmt172_mssql_execute_parameters_comma_space** = **n**, type: **int**.
    

  EXEC  Sptrackmember @p_member_id
      , '2.2'
      , @p_weeknum 

• Format SQL inside string literal

  Turn this SQL:

  EXECUTE ( 'CREATE TABLE AdventureWorks.dbo.SalesTbl  
  (SalesID int, SalesName varchar(10)) ; ' ) AT seattlesales; 

  into

  EXECUTE ( 'CREATE TABLE adventureworks.dbo.salestbl  
               (salesid   INT, 
                salesname VARCHAR(10));' ) AT seattlesales;