679 results found
-
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 -
Allow GitHub public sharing of snippets and styles
Allowing styles or snippets to be shared publicly would be a great feature. This could be potentially be done using GitHub repos and/or Gists.
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 -
Add Feature to Qualify Object Name on files in a folder / directory / sql database
As SQL Prompt user, I want to be able to perform a qualify object names operation on a directory of views, tables, sprocs, etc.
Currently, one must open a sql file in SSMS first then run the qualify object names operation on each file. This is extremely time consuming. We are trying to improve our code quality and readabily by following best practices.
1 vote -
Version Specific Snippets Script Blocks
I would like to be able to specify different script blocks inside a snippet that would work differently based upon the sql server version of the server I am connected to.
Or.... optionally have a version indicator on the snippet to perform the same thing. Then if two snippets share the same name it would apply the correct one based upon version.
EX:
…:if $version_major$ >= 13 CREATE OR ALTER PROCEDURE [$dbo$].[$proc_name$] (@param1 INT) AS BEGIN $CURSOR$SELECT @param1 END GO :else IF OBJECT_ID('[$dbo$].[$proc_name$]', 'P') IS NULL BEGIN EXEC('CREATE PROCEDURE [$dbo$].[$proc_name$] AS BEGIN SELECT 1; END;') END GO ALTER PROCEDURE [$dbo$].[$proc_name$]1 vote
- Don't see your idea?