Activity overview
Latest activity by gerry123
Hi Josh, Yes: Formated in MSMS: [image] [image] Formated with SqlPrompt.Format.CommandLine.exe: [image] 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? [image]
/ comments
Hi Josh,Yes:Formated in MSMS:Formated with SqlPrompt.Format.CommandLine.exe:sqlprompt: 10.14.21.9884SqlPrompt.Format.CommandLine.exe: 10.12.6.30951demo sql:DECLARE @a1 INT = 0;DECLARE @a2 INT = 0;D...
Different format results cmd vs. Visual Studio
Hi,I format a bunch of files in a folder withSqlPrompt.Format.CommandLine.exe --i-agree-to-the-eula -p <folder> -s "Default" -n -is -acIf I do a format in VS with every sql prompt setting = default...