Activity overview
Latest activity by Guenter
Hi Jon, thanks for the hint. That toggle gives me the format I wanted to see! I do remember though, htat there was another issue that took me to set the flag otherwise, but unless I find that again, I'm happy with your solution. / comments
Hi Jon,thanks for the hint. That toggle gives me the format I wanted to see!I do remember though, htat there was another issue that took me to set the flag otherwise, but unless I find that again, ...
After looking at it, the difference seems to come from the option "Collapse statements shorter than 40 characters". When I toggle this setting, the formatting gets right - so maybe it's just a glitch in the shortening formatter? / comments
After looking at it, the difference seems to come from the option "Collapse statements shorter than 40 characters". When I toggle this setting, the formatting gets right - so maybe it's just a glit...
Hi Jan, thank you for your post. If the formatting output on my computer were as you show it, I'd be really happy. But my output looks different: [image] [image] / comments
Hi Jan, thank you for your post. If the formatting output on my computer were as you show it, I'd be really happy.But my output looks different:
SQL Prompt - strange behavior with ROLLBACK TRANSACTION
Hello,in my stored procedures I often use the patternIF @somecindition = TRUE
BEGIN
COMMIT TRANSACTION;
END;
ELSE BEGIN
ROLLBACK TRANSACTION;
END;</code>IF @somecondition = TRUE
BEGIN
COMMIT TR...
The code section seems to have messed up; hiere comes a prettier version: SELECT *
FROM
sys.[objects]
CROSS APPLY (
SELECT
'this column intentionally left blank' AS [blank_column]
,CAST(NULL AS INT) AS blank_int_column
) x;
-- version that I'd prefer
SELECT *
FROM
sys.[objects]
CROSS APPLY (
SELECT
'this column intentionally left blank' AS [blank_column]
,CAST(NULL AS INT) AS blank_int_column
) x;
-- version that SQL Prompt produces
/ comments
The code section seems to have messed up; hiere comes a prettier version:SELECT *
FROM
sys.[objects]
CROSS APPLY (
SELECT
'this column intentionally left blank' AS [blank_column]
,CAST...
SQL Prompt - strange behavior when formatting 'CROSS APPLY'
When using SQL Prompt to format my code, it seems to mess up the indentation each time I use 'CROSS APPLY' or 'OUTER APPLY', as you can see in this example:SELECT *
FROM
sys.[objects]
CROSS APP...
SQL Prompt - strange formatting behavior with "TOP x"
Why does SQL Prompt format SQL statements differently when using "TOP x"?Take these two statements as an example. I would have expexted the exact formatting except for the additional two words "TOP...
Handling two interconnected databases with SQL Source Control
I have an ETL process completely coded in SQL (no change of techology wanted) that uses a StagingDB where the incoming data is stored in the source format and a QueryDB where data is stored in nati...
SQL Prompt for hourly needs, SQL Source Control for daily needs. Without the one I couldn't read code produced by others (long ago) and produce code readably by others (now). Without the other I'd be lost in a dev database used by all developers simultaneously. / comments
SQL Prompt for hourly needs, SQL Source Control for daily needs.Without the one I couldn't read code produced by others (long ago) and produce code readably by others (now).Without the other I'd be...