673 results found
-
Auto generated INSERT needs a column blacklist
Add the ability to exclude columns from appearing in the auto-generated INSERT statements. I have to manually remove certain columns every time.
9 votes -
Add Colors to Database/Server Icons in Object Explorer
Coloring the Tabs is very nice. I would love to have the database/server icons be colored (or at least a small colored dot on them) so I could see at a glance in Object Explorer what server the database is on.
31 votes -
Please include support for Extended Events in SQL Prompt
Extended Events is a great feature in SQL Server. Without support for this in SQL Prompt makes it incomplete.
I know we have a GUI for it in SQL Server 2012. But it will quite sometime before everybody is on the latest version of SQL Server14 votes -
Option to include the schema when generating an alias.
I have tables that repeat in different schemas, for example Supplier.Location and Customer.Location. I'd really like auto-alias to include the schema when generating the alias. Supplier.Location should be SL and Customer.Location should be CL. Instead I end up with L and L2, which is not as clear.
Ideally, I'd prefer the schema characters to be lowercase and the table to be uppercase. Using sL and cL would make my query even more readable.
13 votes -
Spell check on comments.
Spell check on comments would be a nice addition to SQL Prompt. I know there can be misspellings within variables, table or any type of SQL object, but to at least have it in the comments would be nice.
25 votes -
Ability to Save invalid objects list instead of re-running entire database each time
When you are working with a rather large database it would be nice to be able to save a list of invalid objects to come back rather than having to re-run through the entire database again.
6 votes -
Align aliases, commas, datatypes and expressions at the next tab stop
I align aliases, commas, datatypes and expressions at the first tab stop following the longest element in the list. See examples below:
-- Tilde character used as space replacement to cope with HTML formatting
-- 2-character tabs are assumed below
-- In a fixed-space font, the commas, = signs, data types and AS keywords would all line up vertically
DECLARE
~~@x~~~~~~~~~~~~~~INT~~~~~~~~~,
~~@var~~~~~~~~~~~~VARCHAR(4)~~,
~~@longer_varname~VARCHAR(10)~,
~~@z~~~~~~~~~~~~~~DATETIME~~~~;SELECT
~~~~@longer_varname~=~'x'~~~~~~~,
~~~~@var~~~~~~~~~~~~=~'1234'~~~~,
~~~~@z~~~~~~~~~~~~~~=~GETDATE()~;SELECT
~~~~T1.shortfield~~~~~~~~AS~ShortField~,
~~~~AO.reallylongfield~~AS~LongField~~,
~~~~'x'~~~~~~~~~~~~~~~~~~~AS~XChar~~~~~~,
~~FROM~~~~~~~~dbo.table1~~~~~~AS~T1
~~~~LEFT~JOIN~dbo.anotherone~AS~AO~ON~T1.keyval~=~AO.keyval;EXEC~@x~=~dbo.SomeProc
~~@Param1~=~'3'~~~~~~~~~~~,
~~@P2~~~~~=~'Longer~Text'~,
~~@P3~~~~~=~4~~~~~~~~~~~~~;27 votes -
Right-click highlighted table and "Create Alias"
When I find I want to define my own table Alias within SQL Prompt, I must go to the menu, click SQL Prompt, scan down for "Options", scan down for "Aliases", click "New" and then do something useful.
Please obviate ALL THIS, by giving a right-click fastpath to "Add Alias" while in the script editor. If the table name happens to already exist, please position the list at it (just in case SQL Prompt had issues...)
It is very laborious to have to navigate through all these clicks just to add an alias while in the code.
17 votes -
Add a new "Modify" menu item when right clicking views in Object Explorer
To get an ALTER script for an existing stored proc or UDF you just need to right click it in Object Explorer and select Modify. For views you can't do this. You have to select "Script view as.." then "Alter to..." then "New query editor window". It's only two extra mouse clicks but they are two very annoying mouse clicks! I was hoping this would have come back for SQL2012 as you used to be able to do this in SQL2000, but it hasn't. Redgate to the rescue?
18 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…9 votes -
JOIN hints based on a view's underlying table's foreign key constraints
When joining views, the only suggestions currently available are for columns with the same name. It would be nice if, for simple enough views, SQL Prompt looked at the underlying tables for foreign key constraints and use them in the suggestions.
38 votes -
Have column selector available on insert statements
I noticed as a new user that when I type in INSERT INTO [table_name] ( column1, etc) that the column selector option is grayed out. When building insert statements that use a select to provide the data being inserted I have to manually select each column. Could you enable column picker in an insert statement?
5 votes -
Automatically find unused variables and parameters
I would be nice to have an option i behavior to automatically finding unused variables and parameters. (like suggestions / definitions)
87 votes -
Better tab management
1)Automatically name tabs generated by modifying a stored procedure in the Object Explorer. I noticed you added the functionality to right-click on a procedure name in-line and generate an ALTER script. That's AWESOME, and even more awesome is the fact that the tab is named by default. Usually tabs in SMS have some dynamically-generated name that's useless.
2) add ability to rename a tab without saving the contents of the tab. Just a right-click->Rename
3) Hovering over a tab should give you a pop-up with the first dozen or so lines of text in that tab.106 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 -
Bulk Smart Rename
Enhance Smart Rename to accept a list of name changes.
Even if it runs the existing smart rename and concatenates the scripts it would save a lot of data entry time versus doing each change one at a time.
You should require fully qualified names in the import data to avoid ambiguity errors.
58 votesWe’re going to be reviewing this over the next couple of months, which would be released via the SQL Prompt for Teams EAP (get in touch if you want to know more).
In the meantime please add any other information that you think would be useful.
-
Automatic Suggestion Refresh
If I am running an "ALTER" or "CREATE" or "DROP", etc. Have SQL Prompt automatically refresh suggestions after my call.
17 votesThe team are currently reprioritising this suggestion with a view to picking it up during 2019.
-
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 -
Better memory management
Sql Prompt is a memory hog and causes SSMS to routinely be my biggest consumer of available memory. I just opened SSMS and refreshed the objects in a rather large database and SSMS is consuming 572 MB of memory. When you compare this to the 92 MB that SSMS uses on a fresh start up the difference is quite shocking.
16 votes -
Smart Rename should include renaming a Schema
Self explanatory... Need to right-click a user-defined schema and be able to generate a script that effects the scema rename and code within all affected objects. Would be great to add a list of additional databases in which to look for candidate objects to change: triggers, SPs, UDFs...
12 votes
- Don't see your idea?