SQL function

• Parameters

  • Fit into one line

    SET @a = dbo.Func1(@param1, @param2, @param3 + 1, @param4) 

  • Stacked parameters

    • Comma at the end of line

      SET @a = dbo.Func1(@param1, 
                         @param2, 
                         @param3 + 1, 
                         @param4) 

    • Comma at the begin of line

      SET @a = dbo.Func1(@param1
                         ,@param2 
                         ,@param3 + 1
                         ,@param4) 

    • Comma at the begin of line, align parameters

      SET @a = dbo.Func1(@param1
                        ,@param2 
                        ,@param3 + 1
                        ,@param4) 

    • Comma at the begin of line, align parameters, space between comma and space is 1 or n

      SET @a = dbo.Func1( @param1
                        , @param2 
                        , @param3 + 1
                        , @param4) 

• Decode function

  SELECT last_name, 
         DECODE(job_id, 'It_prog', 1.10 * salary, 
                        'st_clerk', 1.15 * salary, 
                        'sa_rep', 1.20 * salary, 
                        salary) revised_salary 
  FROM   employees;