77 results found
-
Intellisense for system stored procedure parameter values
For system stored procedures, some parameters have a predefined set of possible values, e.g.
msdb.dbo.sp_add_jobstephas the parameter@on_success_action.The MS documentation lists this predefined list of possible values:
1 (Default) Quit with success
2 Quit with failure
3 Go to next step
4 Go to step@on_success_step_idIt would be great if Intellisense could suggest values for these sorts of parameters, saving a trip to Microsoft's website.
1 vote -
The automatic aliasing of tables and views could be improved
Say I typed the code below, just to look at the content of a table (don't slam me for the SELECT *, this is pseudo code).
SELECT * FROM dbo.Address AS A
dbo.Address was automatically aliased as "A", which is fine.
Now, let me double-click on "Address" and replace this table name with another one, just because I want to save time:
SELECT * FROM dbo.Affiliation AS A AS A
This time, the table was automatically aliased again, but your feature does not seem to care if the table was already aliases.
So now, the table is double aliased.
3 votes -
Close pop up windows when holding down the control key while editing sql in SSMS
While editing code in SSMS, i often find I want to use control key navigation (ctrl - left arrow for example) to navigate to a different part of the text i'm editing, but a pop-up intellisense window has arrived and instead of moving to the start of the word i'm editing, its trying to make me choose things from its pop up. It would be nice if ctrl key navigation would auto close the intellisense window so I could continue moving around the text of my query instead of having to hit escape all the time to close the pop…
1 vote -
IntelliSense for $partition.<partition_functions>
I would like the Prompt to be able to list any partition function found in the current context (DB)
like when i write: $partition.<Intellisense here>1 vote -
Suggest table names or contsraint names for DBCC CHECKCONSTRAINTS
SQL Prompt should properly suggest table names or constraint names for DBCC CHECKCONSTRAINTS.
The correct syntax would be:
DBCC CHECKCONSTRAINTS('SchemaName.TableOrConstraintName')Currently, it suggests this way:
DBCC CHECKCONSTRAINTS(TableName)
which only works if TableName is in the dbo schema.1 vote -
snippet refresh
Snippet adds or updates are not refreshed until SSMS is restarted.
Can you add a feature to auto refresh the cache of snippets or make part of the "refresh suggestions"
3 votes -
Autocomplete From User Tables
A nice SQL Prompt feature would be autocomplete using contents from user tables. For example, if I have a smallish table (this idea may be impractical for large tables) with a list of codes - state codes, statuses, categories, etc. - and I need to hard-code a value from the table in a query, it would be cool if SQL Prompt could do autocomplete from the contents of the table.
2 votes -
ORDER BY 1 gives incorrect warning
The following gives the warning "ORDER BY clause with constants". In this statement, "1" is not a constant, but a reference to the 1st column.
SELECT TOP (10) Field1, Field2 FROM MyTable ORDER BY 1 DESC
1 vote -
Load Suggestion
When opening a "New Query" window in Sql Server Management Studio (SSMS), SQL promt automatically load suggestions every time.
If the connection with the server is strong, this tipically takes about 1-2 seconds.
I am using a VPN that has a low bandwith and i have to wait 30-40 seconds every time i open such a window.
Since i have the possibility to load the suggestions manually using CTRL + SHIFT + D,
it would be great to have a setting that will prevent loading suggestion in every situation as described above.
Just store the suggestions in the cache first…2 votes -
Exclude standard column names from join suggestions
We add certain standard columns to all tables (LastUpdatedDate for example). Would be great to be able to set a list of these columns in the Options so they can be excluded from list of suggested JOINS
2 votes -
Object tooltips
Include SQL statements to grant existing permissions with the object definition DDL statements.
i.e. GRANT SELECT ON dbo.table TO sql_user1 vote -
Add AI assistance
As AI powered tools like codepilot, kite or tabnine are on the rise, It would be so great to add an AI assistant to SQL Prompt to support developers on their way to write t-sql code effortless.
3 votes -
Azure SQL Intellisense....please!
I do not see Intellisense for AZURE sql. Please, please, please. There's code formatting, but no actual intellisense like ssms.
10 votes -
Support for Synapse Serverless / On-Demand
Please add support for Synapse Serverless Databases for Intellisense!
18 votes -
Where clause should suggest column first, then variable
When typing in a where clause, the column name should be suggested first, then the variable.
1 vote -
Load built-in functions first in the suggestions list
Would it be possible to load built-in functions into the suggestions menu first (or alternatively, ignore keystrokes until the suggestion list is fully loaded)?
An example scenario is I type "max(" and it picks up the first user-defined object name from the menu. It appears the built-in functions are loaded after the user-defined objects (although they appear at the top).
In the attached file, the example is that MaxActionId will be selected when I type "max(" too quickly. This is a small but irritating problem because I have to remember to wait momentarily after typing a function name to avoid…
1 vote -
ADS wildcard extension
Please add the wildcard extension (select * => select col1, col2, ...) to SqlPrompt in ADS, the same as it works in SSMS.
6 votes -
Suggest common day and time constants when a date/datetime field appears as a criteria
When a date or datetime field appears in a WHERE clause, include Suggestions of the following nature and dynamically substitute them upon selection with the nondeterministic or deterministic equivalents:
(I couldn't get my table to format nicely here - please see the copy in the uploaded file.)
(If it's currently 11am on Friday August 20 2021...)
Suggestion Nondeterministic replacement Deterministic replacement
now GETDATE() CAST('11am 20 August 2021' AS DATETIME)
today CAST(GETDATE() AS DATE) CAST('20 August 2021' AS DATE)
yesterday DATEADD(DAY, -1, CAST(GETDATE() AS DATE)) CAST('19 August 2021' AS DATE)
tomorrow DATEADD(DAY, 1, CAST(GETDATE() AS DATE)) CAST('21 August 2021' AS DATE)…1 vote -
Make the column picker the default tab when suggesting columns inside a select
Make the column picker the default tab when suggesting columns when the ursor is inside a select statement.
2 votes -
Insert Snippet on New Query
Automatically insert a snippet as soon as you start a New Query in SSMS. I want all my developers to always start every script with a comment block with their username, date and a description of what the script is supposed to do. A shared snippet is already handy for this, but adding this could make it easier to build that habit for new team members.
2 votes
- Don't see your idea?