blank lines between sql stmt in blocks (begin/end)
gFmtOpt.BL_BlanklinesBetweenSqlInBlock
integer
default: 0
blank lines between sql stmt in top level
gFmtOpt.BL_BlanklinesBetweenSeparateSql
integer
default: 0
empty line of before first stmt in block
gFmtOpt.BL_NoBlanklinesBeforeFirstSqlInBlock
boolean
default: true
handle of empty lines
gFmtOpt.EmptyLines
TEmptyLinesOption
eloRemove
eloMergeIntoOne
eloPreserve
SQL before beautify
USE AdventureWorks;
GO
IF OBJECT_ID (N'dbo.ISOweek', N'FN') IS NOT NULL
DROP FUNCTION dbo.ISOweek;
GO
CREATE FUNCTION dbo.ISOweek (@DATE datetime)
RETURNS int
WITH EXECUTE AS CALLER
AS
BEGIN
DECLARE @ISOweek int
SET @ISOweek= DATEPART(wk,@DATE)
--Special cases: Jan 1-3 may belong to the previous year
IF (@ISOweek=0)
SET @ISOweek=dbo.ISOweek( DATEPART(yy,@DATE))
--Special case: Dec 29-31 may belong to the next year
IF ((DATEPART(mm,@DATE)=12))
SET @ISOweek=1
RETURN(@ISOweek)
END;
GO
SQL after beautify
USE adventureworks;
GO
IF Object_id ( N'dbo.ISOweek', N'FN' ) IS NOT NULL
DROP function dbo.isoweek;
GO
CREATE FUNCTION dbo.isoweek ( @DATE DATETIME )
RETURNS INT
WITH EXECUTE AS caller
AS
BEGIN
DECLARE @ISOweek INT
SET @ISOweek = Datepart ( wk, @DATE )
--Special cases: Jan 1-3 may belong to the previous year
IF ( @ISOweek = 0 )
SET @ISOweek = dbo.Isoweek ( Datepart ( yy, @DATE ))
--Special case: Dec 29-31 may belong to the next year
IF (( Datepart ( mm, @DATE ) = 12 ))
SET @ISOweek = 1
RETURN ( @ISOweek )
END
;
GO