Activity overview
Latest activity by RLilj33
Thanks Alex. It clarifies the answer, but my request remains. In a simple block of code, allow for formatting the code without checking the full syntax. / comments
Thanks Alex. It clarifies the answer, but my request remains. In a simple block of code, allow for formatting the code without checking the full syntax.
Request moved to forum. https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/36353782-trim-white-space / comments
Request moved to forum.https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/36353782-trim-white-space
I opened a feature request as indicated by Jessica R. https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/36353671-apply-casing-formatting-as-i-type-but-without-the / comments
I opened a feature request as indicated by Jessica R.https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/36353671-apply-casing-formatting-as-i-type-but-without-the
Alex - I am using version 9.2.1.5713, and can format the individual sections as you indicate. But I see what is happening: I have to select a fully parse-able section of code in order for Format SQL to work. Consider the following code block - Format SQL can't handle this: ( @id dtID = NULL, @date dtDATE = NULL, @num dtNUMBER = NULL, @string dtSTRING = NULL, @bit BIT = NULL, @char4 dtCKCODE = NULL, @flag dtFLAG = NULL )
I would have to select the entire procedure to do it. Format SQL can handle this:
create procedure a
(
@id dtID = NULL,
@date dtDATE = NULL,
@num dtNUMBER = NULL,
@string dtSTRING = NULL,
@bit BIT = NULL,
@char4 dtCKCODE = NULL,
@flag dtFLAG = NULL
)
as
print ''; That's fine on a small procedure, but can be a challenge when working with a complex procedure. Would be better if the selected code could be formatted instead. Thanks, Ryan P.S. Not sure why a semicolon is showing up after each parameter name on this thread when I post the question - those aren't there in the code.
/ comments
Alex - I am using version 9.2.1.5713, and can format the individual sections as you indicate. But I see what is happening: I have to select a fully parse-able section of code in order for Format SQ...
SQL Prompt new feature: Apply Casing as you type
Currently, SQL Prompt either allows you to apply casing all at once with the Apply Casing Options, or it does it as you type if Enable Suggestions is turned on. Please add a feature so that I can h...
Sherry - In the SQL Prompt menu, deselect 'Enable Suggestions'. The keyboard shortcut is Ctrl+Shift+P. Ryan / comments
Sherry - In the SQL Prompt menu, deselect 'Enable Suggestions'. The keyboard shortcut is Ctrl+Shift+P.Ryan
SQL Prompt feature enhancement: apply Format SQL to selected text
Please add the ability to format only highlighted code when using the Format SQL option / Ctrl+K, Ctrl+Y.Thank you,Ryan
SQL Prompt new feature request: Trim white space in T-SQL code
Please add an option be added to SQL Prompt to trim all white space.Ideally, the following would be supported:
Ability to execute against a query window or block of selected code
Available as a sta...