Different format results cmd vs. Visual Studio

gerry123

Hi,

I format a bunch of files in a folder with

SqlPrompt.Format.CommandLine.exe --i-agree-to-the-eula -p <folder> -s "Default" -n -is -ac

If I do a format in VS with every sql prompt setting = default I get a slightly different result in the comments:

JoshH

Hello Gerry, 

I noticed this wasn't addressed yet. Can I ask if you are still having the issue? 

gerry123

Hi Josh,

Yes:
Formated in MSMS:

Formated with SqlPrompt.Format.CommandLine.exe:


sqlprompt: 10.14.21.9884
SqlPrompt.Format.CommandLine.exe: 10.12.6.30951

demo sql:

DECLARE @a1 INT = 0;

DECLARE @a2 INT = 0;

DECLARE @a3 INT = 0;

IF (@a1 = 0) -- if comment1

BEGIN

    SET @a1 = 10; -- comment2

                  -- comment3

                  -- comment4

    SET @a2 = @a1; --comment 5

END;

Now I see there are two versions Version of SqlPrompt.Format.CommandLine.exe, one in
"c:\Program Files (x86)\Red Gate\SQL Prompt 10\"
and one in "c:\Program Files (x86)\Red Gate\SQL Prompt 10\FormatCommandLine". I always used the second one (I think I exctracted it once from a zip). If I use the version directly in "c:\Program Files (x86)\Red Gate\SQL Prompt 10\" the problem is gone. 
Sorry, my fault...

Greeetings
Gerhard

PS: Maybe this is not true for the latest versions?