269 results found
-
Incorrect capitalization of system functions
The SQL Prompt formatter incorrectly tries to capitalize (whether automatically while I type or using the formatter) system functions that are missing a database prefix. For example, SQL Prompt doesn't try to capitalize:
sys.fn_listextendedproperty
but it WILL capitalize
fn_listextendedproperty
as soon as I hit space, regardless of the CASE setting in SQL Prompt's options. Obvious, a capitalized FN_LISTEXTENDEDPROPERTY does not work: the function is case-sensitive.
There does not appear to be a way around this, not even by setting Format -> Styles -> Case -> Buit-in functions to "Leave as is". That only resolves the problem for the manual formatter:…
1 voteThis is fixed in the latest build of Prompt, if you’re still having problems please let me know.
-
Case formatting
Case formatting to allow option of capitalising initial letter only - e.g. Select, not SELECT or select.
1 voteThe latest version of Prompt has the casing option UpperCamelCase which will case SELECT as Select.
-
Tab Magic EAP hijacks CTRL-T completely.
Do not hijack CTRL-T in Tab Magic. I routinely use this to direct query output to Text. I use this in concert with CTRL-D, for output to Grid.
Perhaps when options for Tab Magic are provided, we will be able to turn off this feature.1 voteWe’ve released SQL Prompt 6 which includes the ability to change the keyboard shortcut.
-
Show Long file names in Query History in Tool Tip
Hi,
Thanks for your last changes!
In addition, I have sometime Long file names where only looking on their Name tail or according to their full path, I can decide which one is the relevant.
Could you add in Query History a Tool Tip when hovering above the File Name with Full Name, Path, Last Closed, Last Connection details, etc.?THNX
Jermy1 voteWe’ve released SQL Prompt 6 which includes this.
-
Recognize double quotes for object names in the same way as square brackets.
Please enable SQL Prompt to have the same behavior with double quotes as with square brackets.
For example, typing:
SELECT * FROM [MyTable]
will allow the expansion of the asterisk, while
SELECT * FROM "MyTable"
does not.SET QUOTED_IDENTIFIER is ON by default. Also, many Oracle "converts" use the format "SchemaName"."TableName".
1 voteThis is included in SQL Prompt 6.3, which can be downloaded from http://www.red-gate.com/products/sql-development/sql-prompt/
-
auto suggest when character is added after table is selected so when SalesOrderLine is shows after SalesOrder
Intellisense should pop up when a character is added after table is selected so when there is a table named SalesOrderLine it should be suggested even after the table SalesOrder was chosen via tab if i type further without a space.
1 voteThe latest version of SQL Prompt (6.3) should show the suggestions again once you type the “L” after SalesOrder
-
Please provide intellisense even when not in the current database
In SSMS when accessing a table that is not in the current database (using the three part convention) then no intellisense is coming up for the fields (such as in the where clause)
1 voteSQL Prompt now supports suggestions from other databases when using the three part convention.
Kind Regards,
The Prompt Team
-
Supprt Quoted identifiers for prompting
If you go
SELECT * FROM sys.tables AS t
or
SELECT * FROM sys.tables AS [t]then intellisense will happily carry on working correcly, with t. now showing object members.
However
SELECT * FROM sys.tables AS "t"
and
SELECT * FROM sys.tables AS 't'both cause the intellisense to give up for the rest of the batch. All four identifier markups are valid (for now) and should be treated equally...
1 voteSQL Prompt 6.3 resolves quoted identifiers correctly
-
More options for saving results from grid
When saving results from the grid in SSMS the only option is to csv. It doesn't include headers and if your data has commas in it, the csv file becomes formatted incorrectly. An option to go to excel, or a tab delimited txt file, or choosing the delimiter would be useful.
1 voteSQL Prompt 7.1 includes an “Open in Excel” context menu item. You can download the latest version from http://www.red-gate.com/products/sql-development/sql-prompt/
- Don't see your idea?