admin

This format option controls where to put comma in the list of parameters of SQL Server execute statement. a line break can be placed after comma, or before comma name: exec_parameters_comma_option, default is put line break after comma setting path:…

This format option controls whether list style of parameters in SQL Server execute statement, it can be stacked or wrapped. name: exec_parameters_style, default is stacked setting path: Execute -> parameter style EXEC Spr_store_note   @NoteId = 0,   @TableTypeId = @TABLE_CUSTOMER,   @RecordId = @CustomerId,   @Descr = @Comments  After set exec_parameters_style to…

This format option controls whether align value of parameter of SQL Server execute statement. name: exec_parameters_align_value, default is false setting path: Execute -> align value of parameter EXEC Spr_store_note @NoteId = 0,                     @TableTypeId = @TABLE_CUSTOMER,                     @RecordId = @CustomerId,                     @Descr = @Comments  After set exec_parameters_align_value to true, SQL will be formatted…

This format option controls whether put a blank line before the first parameter of SQL Server execute statement. name: exec_first_paramater_in_newline, default is true setting path: Execute -> first parameter in newline EXEC Spr_store_note   @NoteId = 0,   @TableTypeId = @TABLE_CUSTOMER,   @RecordId = @CustomerId,   @Descr = @Comments    After set exec_first_paramater_in_newline…

This format option control whether put a blank line before comparison operator when it follows a subquery. name: Subquery_Newline_Before_ComparisonOperator, default is false setting path: subquery -> Linebreak before comparison operator SELECT c.[Categoryid] AS [categoryid],        c.[Categoryname],        c.[Picture] FROM   [northwind].[dbo].[CATEGORIES] c WHERE  (((( (SELECT Sum([lpa_l1].[Unitsinstock]) AS [lpav_]              FROM   (SELECT p.[Categoryid] AS [categoryid],                             p.[Unitsonorder]                      FROM   [northwind].[dbo].[PRODUCTS] p                      WHERE  (( p.[Categoryid] = c.[Categoryid] ))) [lpa_l1]) > @p2 ))))  After…

This format option control whether put a blank line after comparison operator when there is a subquery follows. name: Subquery_Newline_After_ComparisonOperator, default is false setting path: subquery -> Linebreak after comparison operator SELECT * FROM   T WHERE  Somefield = (SELECT TOP 1 Blah                     FROM   T1                     ORDER  BY F)  After set Subquery_Newline_After_ComparisonOperator to…

This format option control whether put a blank line after EXISTS keyword when there is a subquery follows. name: Subquery_Newline_After_EXISTS, default is false setting path: subquery -> Linebreak after EXISTS keyword SELECT TOP 1 CASE                WHEN CASE                       WHEN NOT EXISTS (SELECT [lpa_l1].[Categoryid]                                        FROM   (SELECT p.[Categoryid] AS [categoryid],                                                       p.[Discontinued],                                                       p.[Unitsonorder]                                                FROM   [northwind].[dbo].[PRODUCTS] p                                                WHERE  (( p.[Categoryid] = @p1 ))) [lpa_l1]) THEN 1                       ELSE 0…

This format option control whether put a blank line after IN keyword when there is a subquery follows. name: Subquery_Newline_After_IN, default is false setting path: subquery -> Linebreak after IN keyword SELECT od.[Discount],        od.[Quantity],        od.[Unitprice] FROM   [northwind].[dbo].[ORDER DETAILS] AS od WHERE  ( od.[Orderid] IN (SELECT o.[Orderid] AS [orderid]                           FROM   [northwind].[dbo].[ORDERS] o                           WHERE  (( o.[Customerid] IN (SELECT c.[Customerid] AS [customerid]                                                        FROM   [northwind].[dbo].[CUSTOMERS] c) ))) )  After…