Codestyle - SQL: Variables in DECLARE. New Line for each Variable?

Answered

Hi all,

Code Style - SQL.

Anyone mind advising the Code Style option on placing the DECLARE variables on a New Line?

  • The CREATE Procedure parameters are placed on New Line. 
  • The DECLARE variables are always combined to the Same Line -- desired result is for 1 Line, 1 Variable.

 

I've gone through all options and none dictates the DECLARE variables, one per line.

 

Currently:

CREATE PROCEDURE dbo.storedprocname
@parameter1 int,
@parameter2 int

AS
DECLARE @variable1 int, @variable2 int

 

 

 

Desired Result:

CREATE PROCEDURE dbo.storedprocname
@parameter1 int,
@parameter2 int

AS


DECLARE

@variable1 int,

@variable2 int
2 comments
Comment actions Permalink

I created a feature request https://youtrack.jetbrains.com/issue/DBE-7806 based on  your description.

0
Comment actions Permalink

Thanks vasily, much appreciated!

 

Did you still require my Settings?

0

Please sign in to leave a comment.