Devart Forums

Posted: **Fri 13 Apr 2018 14:16**

I have a stored procedure with a body somewhat like this:

CREATE PROCEDURE MyProc
(
	@Var1 INT
)

AS

	-- Comment:
	IF @Var1 IS NULL
		...

Once I format it using SQL Complete, it adds an extra line after the comment to become:

Code: Select all

CREATE PROCEDURE MyProc
(
	@Var1 INT
)

AS

	-- Comment:
	
	IF @Var1 IS NULL
		...

What option can I change to stop that from happening?

Thanks.

Posted: **Mon 16 Apr 2018 13:32**

Please perform the following:
1. Select 'SQL Complete -> Options...' from the main menu. The 'Options' window opens.
2. Navigate to the 'Formatting -> Profiles' branch.
3. Select the active profile and click the 'Edit Profile...' button. The 'Edit Profile...' window opens.
4. Navigate to the 'Code -> IF' section.
5. Unselect the 'Add empty lines around IF statement' option.

Devart Forums

SQL Complete adds extra line after comment

SQL Complete adds extra line after comment

Re: SQL Complete adds extra line after comment