689 results found
-
Add additional option for "remove unnecessary brackets" which would keep brackets around syntax highlighted words. "Status", "Type",etc.",
Add additional option for "remove unnecessary brackets" which would keep brackets around syntax highlighted words.
"Status", "description", and "Type" are examples of special words that are syntax highlighted, but they aren't full reserved keywords, so would want the brackets kept.How to configure and prevent SQL Prompt from removing brackets around Syntax highlighted words?
We only have the following settings:
a) Options > Inserted Code > Special Characters > Brackets > Enclose identifiers within square brackets [] = NO (which is our desire)
b) Options > Format > Styles > Actions > run format > Add/remove square brackets = YES,…32 votes -
Add the command "USE [DatabaseName]" at the top of the script, when using the 'Script Object as Alter F12' feature.
Hi,
I really love the feature to just press F12 on SP and SQLPrompt opens a new query window with an alter script. It improves the productivity and it's a way easier then scrolling or filtering in the object explorer or using the tool tip by copy & paste the definition.Do you know if there is any possibility to add the command "USE [DatabaseName]" at the top of the script. So, in case I need to switch my connection to a different server I don't need to select my database from the available database list drop down in SSMS.
14 votes -
End column guide lines
I think SSMSBoost has this feature: being able to add configurable guide lines to limit the query writing space to a specified number of characters/columns. This is very handy as I always want to keep my code narrow, within the 80-char limit. Currently, I have to install SSMSBoost for it... Could this please be added to SQL Prompt? This is probably a quick feature to implement and would be tremendously useful. Thanks.
3 votes -
Show SELECT INTO within the Summarize Script pane
Within the Summarize Script pane, it would be helpful to differentiate between a SELECT statement (which returns output to the user) and a SELECT INTO statement (which creates a table and loads data into it).
4 votes -
Tab colouring - Job Specific
The Tab Colouring system is brilliant, but I find that I am often working with more than one job at a time that are using the one Database. It would be of great benefit if I was able to Colour my Query Tabs based on which job they are for. i.e.: more than one colour available per Database.
11 votes -
Customize Keyboard Shortcuts
It would be perfect if we could change the keyboard shortcuts, I like to use Ctrl+Enter shortcut to execute current statement (like Oracle SQL Dev) and I can't change the default Shift+F5 on SQL prompt.
11 votes -
Highlight Implicit Conversions due to Data Type mismatch
After spending some time refreshing my memory on implicit conversions, and the potentially disasterous affects on performance, the thought hit me...
Wouldn't it be great if SQL Prompt could hightlight potential implicit conversions when I write JOINS or WHERE statements?
I'm not sure how easy this would be to implement but I know everyone at Red Gate is very intelligent and highly creative so you'll find a way. :-)
74 votes -
MS_Description supporting hyperlink when SQL Prompt is showing the tooltip
I'm currently working on a database with some really complex calculations which are saved then in a table. Putting these formula in the MSDescription is a pain as it cannot be shown correctly in the appearing tooltip text.
A nice Feature would be that I'm able to add a Hyperlink in the MSDescription which is pointing to the document in our SharePoint Server (or Wiki or whereever...).
Or - if this is not working, would it be possible to define a Special RedGate Attribute/Property (e.g. MSDescriptionRedGate) below the MSDescription which is containing a hyperllink and this…4 votes -
Allow Multiple Snippet Folders
Hi, I think it would be useful to add support for multiple snippet folders to the SQL Prompt - Snippet Manager. I would use this by connecting to a set share of snippets that our team uses as well as having my own set of snippets that may be useful only to me.
Thanks for considering,
James17 votes -
Autocomplete stored procedure With DEFAULT Values
When autocompleting a stored procedure statement in the format 'EXEC storedProc @param1 = 0, @param2 0' it would really help if the parameters would initially have the default values defined in the stored procedure (if applicable).
24 votes -
Use icon to denote fields with indexes
When the drop down appears with field names (like when you're typing in a WHERE clause), include a little icon for each field that's the first field in an index (like the key pic when it's the PK).
Being able to say "oh, that one has an index" would help me when trying to figure out how I want to filter things. (aka use "insertedtime" vs "posttime" vs the "start_time"). I'd say to use one icon (maybe greyed out) for non-clustered, and a different (or not greyed-out) icon for the clustered. You already include the field size, so…
16 votes -
Tab Groups
Add the ability to define groups of tabs that are used regularly for different jobs. For instance--there is a group of scripts I use for month end processing and a completely different set of scripts I typically have open for daily processing. Monthly statement preparation and troubleshooting comprise another set of scripts. I'd like to be able to name groups of tabs and retrieve them based on that named grouping, while still being able to go back to what I was doing before the "interruption" that caused me to need a different set of tabs open.
40 votesWe’re looking at improvements to tab history later during 2019 so will review this suggestion.
Interested in demand, so do vote on the suggestion if you would find it useful.
-
Highlight a SELECT stmt and create a temp table definition from it.
Highlight a SELECT stmt and create a temp table definition from it. You often need to create #tables and you have a select to fill it with. However, you have to either create the #table manually or do a SELECT INTO into a real table and then script it out. It would be nice to be able to just take my SELECT and be able to get the #table definition for it.
31 votes -
LINQ Style SQL
What I’m proposing, would change the way we type our SQL scripts. I’m not suggesting we try to pass or force through a new SQL standard. I’m simply suggesting a new dynamic “view” of the SQL syntax, which would allow for a more natural support of intellisense. With today’s IDE’s this simply doesn’t work. Intellisense doesn’t know where to pull the “what” from. The “what” comes from the “where”, (the FROM clause).
The underlying SQL script itself, would still comply with the SQL standards. This “view”, would perform three tasks: 1) allow the end-user to type their SQL more like…
11 votes -
Keyboard macros
Create ability to write keyboard macroses. For example I have following lines:
column1 as varchar(100),
column2 as int,
...
column117 as uniqueidentifier primary keyI want to get all column names. What I usually do, I am copying it to external editors that support macroses and record it on the first line with following actions:
holdctrl+right(cursor goes to the end of column name), holdshift+pressendbutton (highlights entire row),pressdel (to delete this text),press,(to add comma at the end),pressdown(to go to the next row),presshome (to return at the beginning of the second row)
Then I…11 votes -
Indicate if an object is SELECT only or contains data insert/update/delete operations
Often when reviewing someone else's objects I have to open them and scan through to determine if they are truly read only or if they contain data modification code (delete,update, insert, merge, etc...). It would be most helpful if SQL prompt could show a flag for read only vs data mod objects (when you hover over and click to open the summary window displaying it there would be ideal). It would be best if it could check dependencies (if the object called others)
8 votes -
Load suggestions from sql files in Visual Studio/SSDT Projects
Prompt currently needs a database connection to retrieve objects/suggestions from, which it gets from a database project's "Target Connection String".
It would be better if prompt loaded suggestions directly from the sql files in the project without needing the database.
106 votes
Thomas Walsh
responded
Thank you for your suggestion.
We’ve reviewed this as part of our UserVoice triage.
Due to a lack of recent interest in this request, we are no longer actively reviewing it and have removed it’s “Under Review” status.
If you feel strongly about having this feature added to Prompt, please continue to vote for and comment on this request.
Kind Regards,
The Prompt Team -
when aggregating add alias
when doing simple aggregation such as sum(column), it would be nice if the column name would be aliased after the agg automatically. if this is a single column in the function then make the alias the column name. when multiple then create square brackets and move cursor into bracket after closing agg with a ")"
13 votes -
Support for PDW (Parallel Data Warehouse, aka APS)
Work at a company where we're adopting PDW. It would be great if I could get intellisense in PDW.
61 votes -
Indent Guides Line
Sometime, my sql query script have too much nested condition and I need to see the indent guides line like this image:
https://lh4.googleusercontent.com/-qmpRo6zwZTo/U6EzoIkdw7I/AAAAAAAAAYs/ctAXWq5nPwc/w725-h316-no/Untitled.png
It would be awesome if you include this feature in this product.49 votes
- Don't see your idea?