Space inside parenthesis of parameter definition of create function procedure - sqlparser/sql-pretty-printer GitHub Wiki

  • No space inside parenthesis

    Option: fmt095_space_around_parameter_declaration = false, type: TFmtBoolean.

    CREATE FUNCTION sales.Fn_salesbystore 
      (@storeid INT)  
    RETURNS TABLE  
    AS  
      RETURN 0; 
    
  • One space inside parenthesis

    Option: fmt095_space_around_parameter_declaration = true, type: TFmtBoolean.

    CREATE FUNCTION sales.Fn_salesbystore 
      ( @storeid INT )  
    RETURNS TABLE  
    AS  
      RETURN 0;