Blank lines(vertical spacing) in multiple SQLs

Rules specified here maybe overwritten by any rules apply to specific sql statement.

Original SQL:

CREATE FUNCTION dbo.isoweek (@DATE datetime) 
RETURNS INT 
WITH EXECUTE AS caller 
AS 
BEGIN 
     DECLARE @ISOweek INT 
      
      
     SET @ISOweek= datepart(wk,@DATE)+1 
          -datepart(wk,CAST(datepart(yy,@DATE) AS CHAR(4))+'0104') 
           
--Special cases: Jan 1-3 may belong to the previous year 
     IF (@ISOweek=0) 
          SET @ISOweek=dbo.isoweek(CAST(datepart(yy,@DATE)-1 
               AS CHAR(4))+ CAST(24+datepart(DAY,@DATE) AS CHAR(2)))+1 
--Special case: Dec 29-31 may belong to the next year 
     IF ((datepart(mm,@DATE)=12) AND 
          ((datepart(dd,@DATE)-datepart(dw,@DATE))>= 28)) 
          SET @ISOweek=1 
           
           
           
           
     RETURN(@ISOweek) 
END; 
GO 

Delphi

• gfmtopt.EmptyLines, type of TEmptyLinesOption

Java

• public TEmptyLinesOption emptyLines, type of TEmptyLinesOption

Uniform

• Merge blank lines into one blank line

  Option: fmt121_vs_generic = merge_into_one, type: TFmtVerticalSpacing.

  CREATE FUNCTION dbo.Isoweek 
    (@DATE DATETIME)  
  RETURNS INT  
  WITH EXECUTE AS caller  
  AS  
    BEGIN  
      DECLARE @ISOweek INT  
  
      SET @ISOweek = Datepart(wk, @DATE) + 1 - Datepart(wk, Cast(Datepart(yy, @DATE) AS CHAR(4)) + '0104') 
  
      --Special cases: Jan 1-3 may belong to the previous year 
      IF(@ISOweek = 0)  
        SET @ISOweek = dbo.Isoweek(Cast(Datepart(yy, @DATE) - 1 AS CHAR(4)) + Cast(24 + Datepart(DAY, @DATE) AS CHAR(2))) + 1 
      --Special case: Dec 29-31 may belong to the next year 
      IF((Datepart(mm, @DATE) = 12)  
         AND((Datepart(dd, @DATE) - Datepart(dw, @DATE)) >= 28))  
        SET @ISOweek = 1  
  
      RETURN(@ISOweek)  
    END 
  ;  
  GO 

• Merge blank lines into one blank line, insert a blank line after each statement if not exists.

  Option: fmt121_vs_generic = merge_into_one_and_insert_blank_line_if_not_exists, type: TFmtVerticalSpacing.

  CREATE FUNCTION dbo.Isoweek 
    (@DATE DATETIME)  
  RETURNS INT  
  WITH EXECUTE AS caller  
  AS  
    BEGIN  
      DECLARE @ISOweek INT  
  
      SET @ISOweek = Datepart(wk, @DATE) + 1 - Datepart(wk, Cast(Datepart(yy, @DATE) AS CHAR(4)) + '0104') 
  
      --Special cases: Jan 1-3 may belong to the previous year 
      IF(@ISOweek = 0)  
        SET @ISOweek = dbo.Isoweek(Cast(Datepart(yy, @DATE) - 1 AS CHAR(4)) + Cast(24 + Datepart(DAY, @DATE) AS CHAR(2))) + 1 
  
      --Special case: Dec 29-31 may belong to the next year 
      IF((Datepart(mm, @DATE) = 12)  
         AND((Datepart(dd, @DATE) - Datepart(dw, @DATE)) >= 28))  
        SET @ISOweek = 1  
  
      RETURN(@ISOweek)  
    END 
  ;  
  GO 

• Remove all blank lines

  Option: fmt121_vs_generic = remove_all, type: TFmtVerticalSpacing.

  CREATE FUNCTION dbo.Isoweek 
    (@DATE DATETIME)  
  RETURNS INT  
  WITH EXECUTE AS caller  
  AS  
    BEGIN  
      DECLARE @ISOweek INT  
      SET @ISOweek = Datepart(wk, @DATE) + 1 - Datepart(wk, Cast(Datepart(yy, @DATE) AS CHAR(4)) + '0104') 
      --Special cases: Jan 1-3 may belong to the previous year 
      IF(@ISOweek = 0)  
        SET @ISOweek = dbo.Isoweek(Cast(Datepart(yy, @DATE) - 1 AS CHAR(4)) + Cast(24 + Datepart(DAY, @DATE) AS CHAR(2))) + 1 
      --Special case: Dec 29-31 may belong to the next year 
      IF((Datepart(mm, @DATE) = 12)  
         AND((Datepart(dd, @DATE) - Datepart(dw, @DATE)) >= 28))  
        SET @ISOweek = 1  
      RETURN(@ISOweek)  
    END 
  ;  
  GO