Comments
Sort by recent activity
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:
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...
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, ...
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...