Search
-
Moved: Does anyone else's Community CLI not work?
This discussion has been moved. -
Does anyone else's Community CLI not work?
Hello, I installed Flyway Community to get access to the Flyway CLI so I can run "flyway migrate". I found in our current project's setup (it runs "flyway migrate" without any config files), this wasn't doing anything. I uninstalled Community and installed the CLI… -
Re: SmartAssembly 8 - "System.IO.FileNotFoundException: Could not load file or assembly" error
You're welcome. I'm glad the things I learned could be put to use helping someone else! -
Re: Formatting requests - post them here
ELSE IF as one operator instead of:IF...ELSE IF ... ELSE IF ... ELSE IF statement should look likeIF...ELSE IF...ELSE IF...ELSE BOOLEAN OPERATOR indentation (EDIT: Option is in Expressions/Parentheses content) instead ofWHERE condition AND(condition OR condition) WHERE condition AND(condition OR condition) -
SQL Prompt - strange behavior with ROLLBACK TRANSACTION
Hello, in my stored procedures I often use the pattern IF @somecondition = TRUE BEGIN COMMIT TRANSACTION; END; ELSE BEGIN ROLLBACK TRANSACTION; END; When I use SQL Prompt to format this code, the COMMIT TRANSACTION statement is correctly indented (as being in a BEGIN END block), but the ROLLBACK TRANSACTION always ends up… -
Re: SSMS Analysis Services with SQL Search
I have uninstalled SQL Search and still appear to be getting the error. I did update the whole toolbelt suite so could possibly be related to something else? But we have multiple users so it's possible machine needs a restart. -
formatting if else if statements
I want the formatting to be as follows: IF () STATEMENT ELSE IF () STATEMENT ELSE IF () STATEMENT ELSE STATEMENT However, currently, it formats like this: IF () STATEMENT ELSE IF () STATEMENT ELSE IF () STATEMENT ELSE STATEMENT Is there an option that fixes this? -
Re: Ctrl+Shift+D
https://forum.red-gate.com/discussion/90375/anyone-else-have-suggestions-not-working-in-latest-update-of-sql-prompt#latest Had the same trouble, I'd recommend downgrading if you're using PaaS service. -
Re: SQL Format on a merge statement with multiple case statements
its worse if you have multiple case statements, then you end up with CASE WHEN s.COL1= '' THEN NULL ELSE s.Col1 END, CASE WHEN s.Col2= '' THEN NULL ELSE s.Col2 END, CASE WHEN s.Col3 = '' THEN NULL ELSE s.Col3 END -
What is the recommended way to set up Flyway on an Octopus Deploy worker?
I am unable to find documentation on setting up Flyway on an Octopus Deploy worker. We are unable to use an execution container at this time. We have licenses for Flyway enterprise. What flyway product should be downloaded? Where should it be downloaded? What else should be done?
>2116 results
