Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

How to prevent adding "GO" at end ? #287

Open
tormozit opened this issue Jun 24, 2023 · 0 comments
Open

How to prevent adding "GO" at end ? #287

tormozit opened this issue Jun 24, 2023 · 0 comments

Comments

@tormozit
Copy link

tormozit commented Jun 24, 2023

input

SELECT
T1._IDRRef
FROM dbo._Reference26X1 T1
WHERE ? IN
(SELECT
? AS Q_001_F_000_
FROM (SELECT
T3._Fld14500RRef AS Fld14500RRef
FROM dbo._InfoRgSL31415 T3) T2
WHERE (T2.Fld14500RRef = T1._IDRRef))

output

SELECT T1._IDRRef
FROM dbo._Reference26X1 T1
WHERE ? IN (
		SELECT ? AS Q_001_F_000_
		FROM (
			SELECT T3._Fld14500RRef AS Fld14500RRef
			FROM dbo._InfoRgSL31415 T3
			) T2
		WHERE (T2.Fld14500RRef = T1._IDRRef)
		)
GO

I wand to remove final "GO"
I use command line tool SqlFormatter for Windows

is  indentString (default: \t)
st  spacesPerTab (default: 4)
mw  maxLineWidth (default: 999)
sb  statementBreaks (default: 2)
cb  clauseBreaks (default: 1)
tc  trailingCommas (default: false)
sac spaceAfterExpandedComma (default: false)
ebc expandBetweenConditions (default: true)
ebe expandBooleanExpressions (default: true)
ecs expandCaseStatements (default: true)
ecl expandCommaLists (default: true)
eil expandInLists (default: true)
uk  uppercaseKeywords (default: true)
sk  standardizeKeywords (default: false)
ae  allowParsingErrors (default: false)
e   extensions (default: sql)
r   recursive (default: false)
b   backups (default: true)
b   outputFileOrFolder (default: none; if set, overrides the backup option)
l   languageCode (default: current if supported or EN; valid values include EN, FR and ES)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant