Format lists on a clause basis
I would like to control the list behavior on a clause by clause basis so that I can separate the formatting on my DECLARE statements differently than lists within SELECT and INSERT statements. As it stands, these are conflicting changes. So, the only way to get each variable declared on a separate line is to also have every column in other statements on a separate line. I'd like to be able to do BOTH of these:
DECLARE @GUID UNIQUEIDENTIFIER = NEWID(),
@Char CHAR(1) = 'A',
@Int INT = 1,
@Datetime DATETIME = CURRENTTIMESTAMP,
@Decimal DECIMAL(18,10) = 1.0,
@Date DATE = CURRENTTIMESTAMP,
@Time TIME = CURRENT_TIMESTAMP,
@Bit BIT = 1,
@Money MONEY = 1.00,
@Binary VARBINARY(18) = 0x01,
INSERT INTO Test.Test
(ID, Code, Description, Name, ExternalID, CreatedBy, CreatedUTC, LastUpdateBy, LastUpdateUTC, RowVersion,
DLLoadDate, ServerExecutionID
VALUES (@Int, @Char, @Char, @Char, @Char, @Char, @Datetime, @Char, @Datetime, @Binary, @Datetime, @Int)