270 results found
-
Turn Off Schema Collection
I'd like to enable schema collection when I'm writing code, and disable it when I'm doing adhoc queries. Why: We have 100 identical databases with 1900 tables in each database. When I run a query that pulls data from each database sqlprompt starts collecting schema data from all 100 databases, then it runs out of memory and crashes.
The "Turn Off Prompting" option does not help.example:
select id,customer from DB1.dbo.orders where date > @d
union select id,customer from DB2.dbo.orders where date > @d
...etc...4 votesThis is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
"commarise"
When copying a list of items from something like Excel, it would be lovely to have a feature in Prompt which would highlight the list, hit a key stroke and it would place quotes around each item and a comma after them.
It would stop me bashing the quote + arrow + comma keys at the speed of light.
22 votesThis is included in SQL Prompt 7 which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
SELECT DISTINCT starts new line and loses indentation; keep SELECT DISTINCT on same line please.
I believe the DISTINCT keyword should remain on SELECT line but at least maintain the indentation please. Thanks
6 votesWe’ve released support for this piece of formatting in version 8 of SQL Prompt.
You can get the latest version of SQL Prompt from https://www.red-gate.com/products/sql-development/sql-prompt/.
If there is something missing please let us know by opening a new suggestion.
Kind regards,
The Prompt Team
-
unformat
It would be nice to select a small already formatted script, and unformat it by putting it into one line.
5 votesThis is included in SQL Prompt 7 which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Make ctrl+C copy to clipboard work from code popups
When viewing code in a pop-up having hovered over an object e.g. a stored proc, you can only copy by clicking the Copy button (top right). I would like to be able to use ctrl+c
40 votesWe’ve released SQL Prompt 6 which includes this.
-
Merge command formatting options
Please add formatting options for the deferent parts of the MERGE command like you have for INSERT
8 votesThis feature is now included in the new SQL Prompt 8.0. For additional information see: http://documentation.red-gate.com/display/SP8/SQL+Prompt+8.0+release+notes
You can get the latest version of SQL Prompt from http://www.red-gate.com/products/sql-development/sql-prompt/
Thank you for your help!
-
Indent comments consistent with code
I'm finding my comments are hanging out all on their own after the rest of my code is formatted. I would request a feature to allow comments to indent to the same level as the code on the line below.
56 votesThis feature is now included in the new SQL Prompt 8.0. For additional information see: http://documentation.red-gate.com/display/SP8/SQL+Prompt+8.0+release+notes
You can get the latest version of SQL Prompt from http://www.red-gate.com/products/sql-development/sql-prompt/
Thank you for your help!
-
Support for SQL CMD Mode
Please add support for SQL CMD mode. When SSMS is in SQL CMD mode, SQL Prompt pretty much becomes disabled when :setvar is used to define an object (e.g. table) name. Thus, in the code:
:setvar mytable "dbo.mytable"
select * from $(mytable)SQL Prompt is of no use. SQL Prompt should be able to resolve $(mytable) to the base object.
17 votesThis is included in SQL Prompt 6.5 which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Option to sort column lists by table order as rather than alphabetically
Have an option to sort the column list as it appears in the table rather than alphabetically. I have a good memory for where the functionality sits in the table, but I don't always remember the name. Columns are often logically placed in the table.
3 votesSQL Prompt 6.3 will display the columns in their table order rather than alphabetically
-
Add options for CASE WHEN ELSE END
I'd like to be able to configure a style for CASE statements using options like the following:
- New line after THEN
- New line before ELSE
- New line after ELSE
- ELSE match indent of CASE
- END match indent of CASE
It would also be nice to have a threshold setting (in number of characters) so the formatting settings are only applied if the length of a CASE statement exceeds the threshold.
64 votesThis feature is now included in the new SQL Prompt 8.0. For additional information see: http://documentation.red-gate.com/display/SP8/SQL+Prompt+8.0+release+notes
You can get the latest version of SQL Prompt from http://www.red-gate.com/products/sql-development/sql-prompt/
Thank you for your help!
-
Invert Aliasing
As you select a Table say LotBaseLog , we get auto aliasing to give
Select * from LotBaseLog as lbl
What about using the alis in reverse
Select * from lbl
Gives
Select * from LotBaseLog
Have a look at Resharper Camel Hump principal
Maybe an even better shorthand
Mike
2 votes -
Autoformat should not indent begin
Instead of
IF xxx
BEGIN
sss
sss
ENDIt should format as
IF xxxx
BEGIN
ssss
ssss
ENDfor all cases where begin and end are used.
18 votesThis is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Qualify Object names and brackets
I recommend splitting the two as distinct user settings. Qualify objects should have two options: Always and Only When Necessary. The reason is that in many cases, such as a simple select from one tabe, table name in front of each field is simply clutter, adding no value. I fact, I remove them manually, as I am more interested in brackets than qualifying object names.
Brackets setting (new seeting) should have a simple Yes/No option - When set to Yes, for consistency, I recommend using brackets even in aliases (another user requested this already).
Other thant the above, SQL Prompt…
4 votesSQL Prompt now has separate settings for Qualify Object Names and Add/Remove Square Brackets, which hopefully is what you’re after.
You can get the latest version of SQL Prompt from https://www.red-gate.com/products/sql-development/sql-prompt/.
If there is something missing please let us know by opening a new suggestion.
Kind regards,
The Prompt Team
-
suggestion box is sometimes in the way
The intellisense box often obscures data in the grid results payne which requires that I hit esc to close suggestions and then retype or ctrl-space to bring it back up.
Possible solutions:
1) The main reason is that the box is usually much larger than it needs to be. If it would auto size as needed it would take up much less room.
2) an optional transparency setting would be much appreciated. Initially draw the box opaque but when the user stops typing, start fading it out a bit slowly because the user may want to see content below. The…
21 votesTransparency was added as an option in SQL Prompt 9.4.10.
-
Extend the column toolstips with the nullable attribute
Extend the column toolstips with the nullable attribute, like this "ic.Attachment varchar(max) not null (Column)"
4 votesThis is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Intellisense for system stored procedures
I just needed to re attach a database from a single mdf file. Something I do every 6 months or so and every time I have to google the command and its syntax. Would be helpful so SQL Prompt recognised and helped with these and other inbuilt procedures and their parameters, for example:
spattachsinglefiledb
sp_helptext
spattachdb
23 votesIn 6.4 we always provide intellisense for system stored procedures if the query is being run against master.
If you’re running against a normal db then we hide the system stored procedures by default as they clutter the suggestions list. There’s a couple ways to get around this, either by qualifying with “sys.” or using the “List system objects” option. A video on this can be found here https://www.youtube.com/watch?v=i8DOTmHkKo8
-
4 votes
We’ve released support for static code analysis mentioned in the comments in version 9 of SQL Prompt.
You can get the latest version of SQL Prompt from https://www.red-gate.com/products/sql-development/sql-prompt/.
If there is something missing please let us know by opening a new suggestion.
Kind regards,
The Prompt Team
-
inserted and deleted tables should be supported in triggers
There is currently no support for the 'inserted' and 'deleted' tables within triggers. They should be treated as equivalent to the original table that the trigger is attached to.
37 votesThis is included in SQL Prompt 6.3, which can be downloaded from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Lower-Case Keyword Support in Format SQL
Support lower-casing keywords instead of upper-casing them; this makes reading the query far easier as the app-specific bits are more visible
4 votesThis already exists as an option in SQL Prompt
-
CTE Support
It would be nice if SQL Prompt could parse CTE expressions and provide prompts just like for regular tables
14 votesThis issue has been reported non-reproducable in recent versions of SQL Prompt.
- Don't see your idea?