663 results found
-
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 -
coalesce
I often need to wrap a column in a coalesce with 0.
It would be swell if there was a feature where I could select a column, then either right click or Keyboard shortcut to have it wrapped in coalesce.
E.g. select the word
personCount
and have it be replaced with
coalesce(personCount,0) as personCount1 vote -
Revisit "Formatting SQL Transaction"
A previous request titled "Formatting SQL Transaction" was flagged as Completed in 2018; however, no option to adjust the formatting for BEGIN TRAN / COMMIT TRAN blocks exists in the latest release of SQL Prompt version 10.
1 vote -
history connection
As I click open on a query in SQL History it gets displayed in a new tab. However this tab has no active connection. To be able to run the query I have to connect the tab manually to the database.
For me it would be much easier if opening the query from History would also open a connection to the database the query ran the last time.If there are specific reasons why this was not implemented it would still be nice, if there were an option available to automatically connect to the server.
1 vote -
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 -
SQL Prompt doesn't restore connections after restart when using Azure Active Directory - Integrated authentication
There is a bug in SQL Prompt . It doesn't restore connection after restart when using "Azure Active Directory - Integrated" authentication in SSMS 18+ or SSMS 19+.
Tab is opened as disconnected.
1 vote -
When using the "Qualify Object Names" feature, show a drop-down when multiple possibilities exist
e.g.
declare @1 table (a int, b int)
declare @2 table (a INT, b int)SELECT a, b FROM
@1 a
CROSS JOIN @2 bHere there are 2 possibilities for columns a and b, however SQL prompt only suggests the second one. Both should be shown and the user given the chance to choose.
SQL Prompt does not recognize the ambiguity nor alert the user to it (although Microsoft Intellisense does flag the ambiguity). This can result in the user selecting the wrong alias (since only one is presented, apparently the last one found) which can result in hard-to-debug…
1 vote -
Snippet placeholder for currently selected object in Object Explorer
Like the snippet placeholder $SERVER$ inserts the name of the connected SQL server and $DBNAME$ inserts the name of the connected database I would like a placeholder $OBJECTNAME$ that will insert the name of the object already selected in Object Explorer.
1 vote -
Add SQLPrompt feature into SQL MultiScript
Add support for intellisense in SQL MultiScript using SQLPrompt
1 vote -
Tab History should include non-SQL files
SSMS homes files other than .SQL scripts. Sometimes an you closed an execution plan or a deadlock graph you wish you had saved. Tab history should cache non-SQL file types along with standard SQL scripts so you can get these back when you accidentally closed SSMS or after a crash.
1 vote -
Add "Clean install" option during installation
Add "Clean install" checkbox with appropriate warnings and option to back up styles and tab history where the user can specify and/or change the suggested backup location by default. Offer an easy option (inside menu?) to restore from the backup once installed. Take a look at Visual Studio editor options can be exported (backed up to a file) and subsequently restored later.
Also, take a look at nVidia, AMD Radeon (formerly ATI) and perhaps Intel network card driver installers as an example for "clean install".
1 vote -
Correctly bracket Windows users/groups when using CTRL+B,CTRL+B
When adding brackets via CTRL+B,CTRL+B, Windows-based principals (users, groups, etc.) are not correctly bracketed. The brackets are placed around the domain or computer name portion of the principal, instead of the combination of the domain/computer and user/group name.
For example, if this statement is entered
ALTER SERVER ROLE sysadmin ADD MEMBER MYDOMAIN\USER
using CTRL+B,CTRL+B will yield this:
ALTER SERVER ROLE [sysadmin] ADD MEMBER [MYDOMAIN]\USER
instead of the correct syntax:
ALTER SERVER ROLE [sysadmin] ADD MEMBER [MYDOMAIN\USER]
Would also be helpful if principals from NT AUTHORITY and NT SERVICE could be correctly handled.
1 vote -
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 -
SQL Prompt Connection Options
SQL Prompt doesn't allow to exclude servers, only way we can filter out server if we add each database under SQL prompt settings (Suggestions>Connections).
We have busy production server and if we connect to production server, SQL prompt execute series of SQL queries against system database tables. Even though impact is minimal, It would be nice if there is a way filtering out servers rather than just the database objects.
1 vote -
do a tab between the comma and the field and indent it all one tab
Add option to do a tab between the comma and the field and indent it all one tab with the first line double tabbed to keep in line with other fields.
Please see also see forum discussion: https://forum.red-gate.com/discussion/comment/1679921 vote -
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 -
Include snippets in command palette searches
It would be useful to have snippets included when searching in the command palette. Selecting snippet would open snippet editor with focus on the selected snippet.
1 vote -
remove square brackets from keywords like MATCH clause in a graph table join
when formatting SQL, do not automatically add brackets to the MATCH clause when querying graph tables
1 vote -
Include views and unsaved tabs in recoverable tabs
When SMSS closes (either by user interaction or unintended closure), SQL Prompt does not save the tabs when I am working in a view. It only saves the tabs that are queries, saved or unsaved. The problem with this is that many times I am creating a view, or working with views. These are never saved with SQL Prompt, so the tab history feature is more or less useless. Redgate needs to include views and unsaved tabs in the recoverable tabs list.
1 vote -
Bulk Formatting or Bulk Code Analysis
It would be nice if the new Bulk Formatting or Bulk Code Analysis functionality could also target items directly in the database. This would save time because I wouldn't first have to save objects definitions to my computer.
1 vote
- Don't see your idea?