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