693 results found
-
Intellisense for Linked Server connection to MySQL ODBC
I have been using SQL Prompt for awhile and one of the best feature I like about it is the fact that Intellisense works even on Linked Server to other MSSQL databases.
Recently however, I have set up Linked server to MySQL ODBC connections and I noticed that Intellisense is no longer returning the table names and column names in the predictive boxes.
I then tested this to other ODBC connection. I set up Firebird (DB2) and Oracle and Intellisense seems to be working for these (only for table names, not columns but that's better than nothing).
Is there a…
2 votes -
Seperate Profiles between SSMS Versions
So I run 2 different versions of SSMS (Have done for a couple of years), currently SSMS 21 & 22. my question and issue is this. If I have say 8 tabs open in SSMS 21 and close it, it saves them (great feature) BUT if I then open SSMS 22 it will reopens those tabs from SSMS 21 in 22. and if I have both 21 & 22 open and close them both around the same time and reopen 21 or 22 all of the tabs from both combined version open in a single SSMS instance.
See this support…
1 vote -
Spell check variable names
It would be helpful to spell check variable names to write better code. It should be fairly easy to rename those variables since the only exists in the scope of that SQL object. Should probably handled like other code issues which can be disabled.
1 vote -
Joins on NULL column is not distinct from
If you choose a nullable column in a join clause, offer the use IS NOT DISTINCT FROM in SQL Server 2022 and above in addition to =
This would assist in (and alert the user to the fact that they were trying to) join between two columns where you may wish to treat NULL as equal.
1 vote -
Remember Open Solution on Close
If I have a solution open when I close SSMS, I would like it to open the solution and not just the files I might have open in that solution when SSMS closes. Could be an option that you turn off/on.
1 vote -
format grouping sets
format grouping sets in the same way as other lists.
currently they are made into one long line regardless of the wrapping setting.1 vote -
Warn if comparing column to itself in WHERE clause
I would love a warning to prevent the classical mistake of comparing a column with itself instead of with another column in a WHERE clause.
An example is the following, where I would like a warning where one has "qlpd.interimdisbursementid = qlpd.interimdisbursementid" as it should be qlpd.interimdisbursementid = di.interimdisbursementid instead:
SELECT *
FROM dbo.datinterimdisbursement AS di
INNER JOIN dbo.qlirologPayoutServicedata qlpd
ON qlpd.interimdisbursementid = qlpd.interimdisbursementid;1 vote -
Copy (just) 1 or more headers from result
I would like the ability to select 1 or more values in a result and have the (right-click?) option to select header(s). I then have the header, or headers separated with commas in my clipboard.
1 vote -
Search for column in result
I would LOVE! the ability to have a search window with my results from a query, where I type in any part of a column name and it lists all columns containing value I typed in.
By default one is positioned on the applicable column in the result (scrolling if necessary in wider result set), but if one clicks on any column matching value then it positions one on that column in the result.1 vote -
FREEZES SSMS - Add what tool (name) caused the error to the title of an error window
The error popup comes out of nowhere when navigating SSMS tree nodes, notably when selecting a specific database name. I expected it came from SQL Prompt, but there was nothing being logged even when verbose option has been enabled.
The support helped clarify it "probably" came from SQL Source Control installed recently.
Also, the "Send Error Report" never worked.
The error completely freezes SSMS as it is a modal.
It has to be dismissed multiple times and then navigated away from the selected database back to a server's name - quickly using a keyboard.
1 vote -
Refactoring: Convert expression to cross apply
Working with a query that contains the same expression multiple times, I often want to extract all instances of that expression into a CROSS APPLY for readability and ease of modification, e.g. converting something like this horribleness:
select foo = case when bar < 100 then 'a' when bar > 200 then 'b' else 'c' end, count(*)
from baz
where case when bar < 100 then 'a' when bar > 200 then 'b' else 'c' end in ('a','b')
group by case when bar < 100 then 'a' when bar > 200 then 'b' else 'c' endinto something more manageable…
1 vote -
make update notification window resizable or autosize with Windows zoom
I like to use the Windows zoom feature to make text bigger. (Not the dpi size feature, but rather the text size feature listed above the dpi setting.)
With this increased, I cannot see the links in Red Gate update notification windows. I'll open SSMS and get a notification for prompt that I am running 1.0.7 and the latest version is 1.0.8. There is a details link that allows me to upgrade. I can also upgrade by downloading the latest version of the tools from the Red Gate web site.
However, for minor upgrades, I often skip the upgrade process…
1 vote -
Show Code Window Even if Schema is Missing
When I scroll over an object *table, view, function, stored procedure), SQL Prompt typically displays a tooltip that describes what the object is (e.g. Table). I can click on the tooltip and see a script of the object.
However, if I have not included the schema, then I do not get the tooltip, but rather a warning that "Schema name for table or view is not specified" and I am not able to view the object code without either disabling that alert or adding the schema name.
While it may be advantageous to have this rule enabled, it would also…
1 vote -
HoverOver Popup Incorrect
Using SSMS 21.4.8 and SQL Prompt 11.0.6.17341.
Using a derived select to retrieve data then derive select that to change the data types then a third derived select to present the data.
In the inner most SELECT, the fields OrderID and OrderItemID are Integer in both the the Microsoft and SQL Prompt HoverOver popups.
In the outer most SELECT, the OrderID and OrderItemID are Varchar in the Microsoft HoverOver popup but Integer in the SQL Prompt HoverOver popups.
Also in the outer most SELECT, down in the ORDER BY, they show differently hovering over between the Microsoft and SQL prompt…
1 vote -
Alignment of nulls
How can we get the following alignment with nulls? Please review the pre & post images attached
1 vote -
Keyword KEEP_CDC not recognized in RESTORE statement
Add support for the KEEP_CDC keyword. Example:
RESTORE DATABASE MyDB FROM DISK = N'\\SOMEWHERE\MyDB_FULLBACKUP1.BAK' WITH FILE = 1, MOVE N'MyDB_DATA' TO N'M:\SQLData1\SQL_DATABASE\MyDB.MDF', MOVE N'MyDB_LOG' TO N'M:\SQLLogs1\SQL_DATABASE\MyDB_LOG.LDF', RECOVERY, REPLACE, STATS = 1, KEEP_CDC, NEW_BROKER, RESTRICTED_USERCurrently the formatting process errors out.
1 vote -
Option to hide "find invalid object" menu
This feature crash SQL Server because our procedures multi-databases, encrypted and so-one and not a needed feature. But the menu is misclicked lot of times and crash SQL Server.
Could you please, add an option to hide "find invalid object" menu1 vote -
Automate replacing variables with literals for troubleshooting stored procedures
Quite often when troubleshooting a stored procedure, it is helpful to step through it and run each statement individually. In stored procedures that take parameters, though, you need to manually swap out the variable name for a test value in each statement, or put variable declarations and sets in front of each statement.
It would be convenient if SQL Prompt could automate this process. It could check for parameters, prompt the user to provide values for them, then do the variable-to-literal substitution throughout the code. It could then provide an easy way to reverse the change to support committing the…
1 vote -
exclude suggestions
SQL Prompt includes a feature to exclude specific databases – in this case, the master database – we would expect this functionality to reliably prevent any interaction with the excluded databases during code suggestions or IntelliSense operations. The current behavior suggests that the exclusion option may not be functioning as intended.
We expect that when an exclusion is defined, no connection attempt should be made to the excluded database. This would allow all other user databases to be loaded, even if with limited functionality.
pls. check http://productsupport.red-gate.com/hc/requests/333558
1 vote -
Set preferences for automatically numbering new queries
New queries, as users know, have an automatic naming and numbering system:
SQLQuery1.sql, SQLQuery2.sql, SQLQuery3.sql, etc.It would be helpful sometimes if the queries could have leading zeros or maybe even a different lead-in like the name of the solution. For example, SQLSolutionABC might have the default tab names:
SQLSolutionABC001.sql, SQLSolutionABC002.sql, SQLSolutionABC003.sql, etc.
1 vote
- Don't see your idea?