701 results found
-
EI003 to allow variable assignment of MIN and MAX and Scalar-valued function results
At the moment a warning is given "Non-scalar subquery in place of a scalar" when trying to assign a variable to the result of a MIN or MAX query which would only result in a single value. Also get the warning when i create a Scalar valued function and assign variable to result of a call to that. In each of these case only one result can be returned so the warning appears inaccurate and wrapping the result in a TOP 1 { } ORDER BY statement seems an overkill just to remove the warning
2 votes -
Create "declare table" snippets
I am in the process of converting many Stored Procedures to UDFs (for various reasons).
One thing that is irritating is that these SPs often use the SELECT x, y, z INTO #tempTable pattern.
Would that be possible for you to generate the equivalent DECLARE @tempTable TABLE ( x TYPE,y TYPE,z TYPE) statement?
That would have proven to be very helpful!
2 votes -
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 -
When changing connections, if the original database exists on the connection, make it the current database
Often times, when I am changing connections (ie servers), it would be nice to have the current database change to the database I was on prior to the connection change.
For example, if I'm on the database Adventure on Server1 and change connections to Server 2, that the current database change from whatever my default database is, to Adventure as well.
Yes I know I could fix this with a use database command, but I also feel SQL Prompt could just do it for me.
1 vote -
Support strict encryption
Hassan Imam (Support) confirms that SQL Prompt does not currently support the 'Strict' encryption mode introduced in SQL Server 2022. Your connection handling currently treats encryption as a simple on/off option and hasn't yet been updated to support the newer encryption levels (Optional, Mandatory, and Strict).
Please support Strict encryption.
1 vote -
find in results
What would be invaluable is to have a "Find in Results" ctrl+f type functionality whereby you could locate a specific value within the Results - either within a specific column or just within the results generally. Other SSMS add-ins have this capability and it's very convenient!
1 vote -
Format SQL: ability to turn ANY formatting “subcategory“ OFF
A large number of the SQL Format subcategories already give you the drop-down option to leave the current code “as-is”, for that given subcategory. It would be useful if this functionality extended to EVERY formatting subcategory; perhaps by way of an On/Off checkbox.
The use case here: some teams may have agreed-upon formatting rules that only apply to a very small list of all possible formatting subcategories, and want to use Format SQL to automatically deploy these changes onto preexisting SQL statements WITHOUT affecting other formatting subcategories that they don’t care about. This can greatly reduce added noise to DIFFs…
1 vote -
Intercept F5 and warn if nothing selected
When I hit F5 in an SSMS window where I'm trying to DELETE without a WHERE clause, SQL Prompt intercepts this and gives an Execution Warning. That's great. Is there a way to do a similar warning if hitting F5 with nothing selected, which executes everything in the script file?
In my opinion, that is VERY dangerous because I jump back and forth between SSMS and Visual Studio, where F5 just runs a program. I rarely would want the F5 to execute everything.
Of course, it would need to be an option that could be turned off via “Don't show…1 vote -
Search - Add multi select and Remove query
SQL History Search - Add multi select (CTRL+click and/or Shift+click) and Remove query option
1 vote -
Fix bug that causes SQL Prompt to crash when RedGate_SQLPrompt_CommonUI_Options_UIOptions.xml is locked
SSMS will freeze up and become unusable whenever RedGateSQLPromptCommonUIOptionsUIOptions.xml is being used by another program. Users can no longer use SSMS when this occurs and need to restart their computer when this happens. This has been very disruptive for the development team as this occurs multiple times per week.
1 vote -
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
- Don't see your idea?