Activity overview
Latest activity by romu_ecosys
Original: IF @IsHoliday=1
SET @DayState = 3
ELSE
SET @DayState = 1
After Reformat: IF @IsHoliday = 1
SET
@DayState = 3
ELSE
SET
@DayState = 1
Our proposal would be that for standalone set statements there never should be a newline (although we have opted for 'First Column On New Line'.
Not a big thing, but I guess others might want that as well...
Roland / comments
Original:IF @IsHoliday=1
SET @DayState = 3
ELSE
SET @DayState = 1
After Reformat:IF @IsHoliday = 1
SET
@DayState = 3
ELSE
SET
@DayState = 1
Our proposal would be that ...
Incorrect layout of INSERT and UPDATE in StoredProc?
Hello,
we have set the layout to get the following for SELECT statements:SELECT
@newUserFullName = dbo.fnFormatName(Firstname, Lastname, Title),
@newUserUserName = UserName
from
...
Logical operator on single line
SQL Refactor: great stuff
One thing that we miss is the option 'logical operator on single line'
We use to format sql this way:select
col1,
col2
from
tbl
where
expr1
and
expr2
I kno...