SQL block indentation

• If SQL block of create function/procedure is a single statement

  CREATE PROCEDURE humanresources.Uspgetallemployees  
  AS  
     SELECT lastname, 
            firstname, 
            jobtitle, 
            department  
     FROM   humanresources.vemployeedepartment;  

• SQL block with BEGIN/END keyword

  CREATE PROCEDURE humanresources.Uspgetallemployees  
  AS  
  BEGIN  
    SELECT lastname, 
           firstname, 
           jobtitle, 
           department  
    FROM   humanresources.vemployeedepartment;  
  END  

  • Specify indentation size of BEGIN/END keyword

    CREATE PROCEDURE humanresources.Uspgetallemployees  
    AS  
      BEGIN  
        SELECT lastname, 
               firstname, 
               jobtitle, 
               department  
        FROM   humanresources.vemployeedepartment;  
      END