73 results found
-
Add possibility to make snippet for "GROUP BY 'by all non-aggregated columns'"
I use GROUP BY only for 'by all non-aggregated columns' in 99% of cases. I've created snippet for GROUP BY (gb) and then I pick this option from the intellisense menu. It would be nice to have possibility to have snippet that would add these 'all non-aggregated columns' automatically most probably by adding new variable.
3 votes -
Warn about always true WHERE clauses such as ID = ID instead of ID = @ID
It is common to create functions and stored procedures that have parameters with the same name as fields. Sometimes the @ is mistakenly skipped when creating a WHERE condition and you end up with something like ID = ID instead of ID = @ID. I would like intellisense that warns me about this type of error.
2 votes -
Snowflake
Please add Prompt features when connecting to a Snowflake database
2 votes -
global temp intellisense
I use global temp tables (##), and intellisense doesn't pick them up, even after a refresh.
3 votes -
Intellisense for Indexes and Constraints
When I have a table with multiple indexes and I want to determine if a certain column or group of columns are part of an index, I basically have to script all of the indexes.
I would like to be able to hover over an index name in the Object Explorer and have SQL Prompt display the index definition without having to script it.
Same with constraints.2 votes -
backup
I would like to see intellisense provide you a list of backup devices that are created when you use the backup database key words.
Backup database [database names in drop down] to [ disk, file, Url, backup devices in dropdown]
1 vote -
Custom Rank Suggestions
Could see there are ranked suggestions, which is good.
Can we take this to next level by letting user add custom ranking to suggestions to see those we rank always at the top but with a requirement that you need to enter at least a single letter so that your custom suggestions starting with that letter would be the first in order of display.Thanks!
3 votes -
Put DISTINCT Keyword At Top of Suggestions List
Add an option to have the DISTINCT keyword appear at the top of the suggestions list when the first few characters (DIS, DIST) are typed, ahead of any column name suggestions. Nearly every time I type DIS or DIST, I want the DISTINCT keyword and not a column name that begins with the same letters.
1 vote -
Order By - Enhancements
I often need to have Order By added and the following enhancements will help (same as in the grupy by intellisent)
- order by "Primary Keys" -> Order as in table
- order by Select-list columns -> order as in the select list
- order by Select list columns from table x
All three would help to type less
Thanks
1 vote -
warning when dropping a object having dependencies
If I write "drop sv_myview" and this view is used in other views (has objects, which are dependend on it) there will be great a warning: "This object has objects, depending on it. Drop anyway?" So I can first recode the dependent objects and then drop it.
2 votes -
FIX Intellisense
I have version 10.0.1.12389 please have sql prompt STOP trying to complete things after a single Apostrophe. VERY Annoying
2 votes -
Jumping to Begin and Jumping to END
Hello,
I try some Add ins for sql server and i found a very interesting and useful functionnality on Softtree sql assistant.
When we have a very large Stored procedure for example, with several BEGIN and END , softtree have a functionality when i place the mouse on BEGIN to [Jump to end] to find the corresponding END, the opposite is also true, when i Place the mouse on END [Jump to begginning].
This functionnlity is very very useful.
I hope you consider developing the same functionality in your SQL Prompt.Best regards,
Luis6 votes -
Temporarily Elevate Exact Matches Over Recently Used Suggestions
I like the new feature to put recently-selected items at the top of the list for Intellisense. However, when I have typed an exact match, I would like to see Intellisense elevate that exact object to the top of the list.
For example, suppose I have recently selected a table named "dbo.OrderDetail", and suppose that there is another table in the same database called dbo.Order. With the new feature, I cannot access "dbo.Order" as the top candidate, because it is a partial match of "dbo.OrderDetail," and so SQLPrompt puts that name at the top.
In a nutshell, I would like…
6 votes -
Writing text within quotes
When typing a string of text within a quote, do not replace my text with objects from the database.
3 votes -
Insert Default Values should include default values defined on the table.
For example, if a table is defined as such :
CREATE TABLE dbo.T1 (
col1 INT DEFAULT 100,
col2 VARCHAR(100) DEFAULT 'Example',
col3 DATETIME DEFAULT '01/01/2019'
)And use auto-complete to generate and INSERT, it will produce :
INSERT INTO dbo.T1( col1, col2, col3 )
VALUES( 0 -- col1 - int
,'' -- col2 - varchar(100)
,GETDATE() -- col3 - datetime
)Instead, it would be nice to have it produce the insert with the defined table default's, something like :
INSERT INTO dbo.T1( col1, col2, col3 )
VALUES( 100 -- col1 - int
,'Example' -- col2 - varchar(100)
,'01/01/2019…5 votes -
with check check
The constraint name is not suggested when using the syntax
"ALTER TABLE <TableName> WITH CHECK CHECK CONSTRAINT <ConstraintName>The suggestion feature works great when using NOCHECK CONSTRAINT
1 vote -
Display intellisense for view columns from underlying base tables
When working with views, you lose the intellisense for columns. It would be nice if SQL Prompt could get the MS_Description value for the view column from the underlying base table for the view.
3 votes -
Correct Inaccurate suggestions for auto complete of column name
Intellisense brings up 'd', CREATE SQL Server login, to top of suggestions when referencing a column beginning with 'cl'.
Specifically, I see this in the where criteria. Have no clue why it would even bring up a 'CREATE SQL Server login' snippet in the context of a WHERE; especially when the autocomplete is coming from the dot to an alias of the table.1 vote -
RedGate In Clause
When redgate is writing the "in clause" for us based on selected cells it would be nice if it also put the column name in the clipboard when all fields selected are from the same column,
1 vote -
inserting table adds database name
When you select a table from the intellisense list
Precede the table name with the database name as well
Currently it is only inserting the schema name in front of the table name
i.e. dbo.<table name>It should be <database name>.<schema name>.<table name>
2 votes
- Don't see your idea?