- or
No existing idea results
- ~ No ideas found ~
674 results found
-
Multiple rows of tabs
If I have more open tabs than can horizontally fit the window SSMS does not show all of them but instead there is a dropdown in the right upper corner. I would prefer if I could have multiple rows of tabs instead, like in VS. Since it does not seem likely that MS is going to implement that soon, can it be done in SQL prompt?
33 votes -
Ability to generate SELECT test script from an UPDATE statement
When debugging an UPDATE statement, it would be handy if SQL Prompt could generate a test Select script that converts
UPDATE xxxxxx
SET SalesPeriod = dddddd,
SalesYear = yyyy,
CustomerCode = zzzzz
...into
SELECT dddddd as SalesPeriod,
yyyy as SalesYear,
zzzzz as CustomerCode
....Optionally, could include all columns involved in joins or WHERE clauses
11 votes -
Execute current statment
Shift-F5 is great but I think this change could make it better.
Before I discovered Shift-F5 and when I had multiple sql statements in my window, I would select the block of sql I wanted and hit F5 to just execute that code block. Then I discovered Shift-F5 and I no longer had to select my sql block it was done for me - but what it doesn't do is actually select the code block, instead it just highlights it in green and executes it. So if you just do an F5 (out of habit) after a Shift-F5 it won't execute the green code block it will run everything in the code window (which sometimes is dangerous and not usually what you meant to do). My suggestion is instead of highlighting in green can you just actually select the block of code - that way if we (out of habit) hit F5 the second time the same code block is executed again? Thanks.Shift-F5 is great but I think this change could make it better.
Before I discovered Shift-F5 and when I had multiple sql statements in my window, I would select the block of sql I wanted and hit F5 to just execute that code block. Then I discovered Shift-F5 and I no longer had to select my sql block it was done for me - but what it doesn't do is actually select the code block, instead it just highlights it in green and executes it. So if you just do an F5 (out of habit) after a Shift-F5 it won't…9 votes -
Keep pinned status
In SSMS 2016 you can now Pin tabs. When you close and re-open SSMS, it would be good if Tab History could remember, and restore, the pin status for each of the tabs as they are being restored.
41 votes -
Prefered server Connection List
When working all day long with serveral SQL servers, its really annoying to click on "change connection" button + enter the server name you want to connect to, and enter credential.... It would be really great we we would have a "server connection list" where we could build into settings.... So i could add all my server i'm use to connect everyday, and specifying the USERNAME + PASSWORD + Default DB..... So in one-two click, i could switch to another server really quicly
29 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 -
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 -
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, remove unnecessary brackets = YES (our desired result)
BUT, we do not want the square brackets removed from BLUE special syntax highlighted words, of course. How to do this?(In SQL Prompt the "remove unnecessary brackets" setting means it'll remove all the brackets that aren't needed to run the script. If you had a fully reserved keyword like While or Table, then the brackets around it would be necessary to run the script.)
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 -
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 is then shown under the Standard tooltip?
It would really help to simplify the documentation and I guess it could be also useful for the SQLDocI'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 -
Keyboard shortcut to comment/uncomment PRINT statements.
I'd like a feature with keyboard shurtcut to comment/uncomment the TSQL PRINT statements.
11 votes -
Auto generate parameters based on a scan of a query
I tend to debug SSRS queries/scripts quite a lot in SSMS. Usually these queries contain 1-10 parameters. It would save large amounts of time if I can paste the query into SSMS and run some SQL Prompt command to auto generate at the top of the query all the parameter declarations ready for default values.
8 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.
10 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 -
prevent Prompt SQL from destroying bookmarks
If format SQL makes chnages - it destroy saved marks
This occurs even when line bookmarked line hasnt (visibly) changed
Very frushtrating3 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 -
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 why not this? Thanks!
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 -
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 -
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. :-)
73 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 replay this macro and I have just column names.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
- Don't see your idea?