271 results found
-
When Formatting, Place Short Queries on a Single Line
I would like the option to specify that queries under a certain number of characters be formatted to be on a single line. This would also apply to subqueries so that if they are over the specified limit it follows the formatting rules already in place for subqueries but places simple subqueries on a single line.
So
SELECT
*
FROM
TABLE
WHERE
COL1 = 5;would become
SELECT * FROM TABLE WHERE COL1 = 5;
and
SELECT
COL1,
COL2,
COL3,
COL4,
CASE WHEN COL5 = 50 THEN 'A' ELSE 'B' END
FROM
TABLE
WHERE
COL1 IN (
SELECT
COLB
FROM…2 votes -
Snippet - Wrap selected text in snippet
SQL Prompt has a fantastic feature that allows selected text to be wrapped up by pressing control + selecting snippet that utilizes the SELECTEDTEXT value. This is great for wrapping up text in "Begin try", "comment blocks" and other selection oriented snippets.
2 votes -
format json output
Add an option to format JSON output with proper indentation and line feeds
2 votes -
region collapse auto
I would like the options to enable such a setting that when procedures, functions, etc. are opened for editing, all regions would automatically collapse. There could also be a keyboard shortcut that collapses and expands all regions
2 votes -
Enable command execution in query result pane
I very often use T-SQL to create a series of T-SQL commands to be run.
I need to ctrl-C+open new window+ctrl-V+F5 to accomplish that, and it works.
However, a nice feature would be to just be able to select the commands in the query result window, and choose "execution" from the shortcut menu, and have SQL Complete do all the additional work automagically.2 votes -
Add Troubleshooting solutions in error tooltips
Example 1:
If you are using a NOT declared variable @var1, @var1 will get underlined and there is a tooltip with the error.
On the tooltip there could be a suggestion: "add declare @var1 int".
Example 2:
If you are executing a procedure and you are missing some mandatory parameters then there could be the solution "add missing parameters" on the tooltip2 votes -
Integrate SSMS with CoPilot
We have already GitHub CoPilot for Visual Studio.
Integrate please it also with SSMS. Or directly ChatGPT2 votes -
Extend Insert Highlight Occurences feature to show popup with column name in the values area
when typing out the values for an insert statement
SSMS should popup an infotip very much like when inserting parameter for functions in Visual studio C# code.
e.g. After typing the , (comma). SSMS should show a popup
Insert into Person.Address
(
AddressLine1
, AddressLine2
,City
,StateProvinceID
)
Values
(
,N''
,N''
,N''
, __________________________#
StateprovinceID int not NULL #
_________________________#
^ popUP
2 votes -
2 votes
-
Add "Search" button to execution history and disable auto-search option.
When searching in execution history, the search value is used pretty quickly after you stop typing. This means that you have to wait for the search to finish even if you weren't done typing the search string. It also means that if you have a typo, you have to wait for the search to finish before you can correct it. I keep a long history of executed SQL, so each search takes a while to run.
In my opinion, it would be better to have a dedicated "Search" button so that you could submit your search string when you're finished…
2 votes -
Customizable dictionary for auto complete
It would be great to have the ability to add some keywords didn't popup for auto-complete, like TRANSACTION, CURSOR,...so users have the control of what they need to be popup automatically.
1 vote
AdminDevart
(_, Devart)
responded
Could you please provide us a concrete example of when it’s needed?
-
Format declare statement with assignment from select statement eg DECLARE @sourceTrackId int = (SELECT Id FROM Track t WHERE t.TrackCod
Declare with select assignment does not format very well.
DECLARE @sourceTrackId int = (SELECT
Id
FROM Track t
WHERE t.TrackCode = @sourceTrackCode)1 voteAdminDevart
(_, Devart)
responded
Could you please send us the screenshots of the actual and expected results to our support system at supportATdevartDOTcom for investigation?
-
Allow formating on ctl-K, ctl-F to be disabled.
I have another tool I'd prefer to use for formatting, but SQL Complete captures the "ctl-k, ctl-f" clicks, preventing me from using the other tool.
1 voteAdminDevart
(_, Devart)
responded
Could you please let us know what version of SSMS or VS you are using?
Please note that in some versions Visual Studio or SSMS you can redefine shortcuts for the commands of dbForge SQL Complete (the command contain ‘SQLComplete’) in the ‘Environment → Keyboard’ section of the ‘Options’ window that can be invoked by selecting ‘Tools → Options’ from the main menu.
Also, please let us know what tool you prefer for formatting and why you chose it over dbForge SQL Complete.
You can reply straight to our support system at supportATdevartDOTcom
-
Popup 'select top 100'
I often find when writing queries in the Sql editor that I want to see a sample of data from the table I'm working with. It would by good if I could right click on the table name in the text editor and have a 'select top 100' option in the popup menu
1 voteAdminDevart
(_, Devart)
responded
You could use the snippets functionality of dbForge SQL Complete.
The snippet can be as follows:
SELECT TOP $count$ *
FROM $schema$.$table_name$ -
Collation names enclosed in square brackets is invalid
I have "Enclose identifiers within square bracket" set to "Always", which in most cases are great.
However, collation names are also being enclosed in square brackets, which seems to be invalid.
Please correct.1 vote
AdminPMs
(Admin, Devart)
responded
Could you please specify what product version you are using?
A video or screenshots would be also of help.
-
Better intellisense for temp tables for DROP TABLE IF EXISTS
I frequently have code like this:
SELECT *
into #mytemptable
FROM mytable mand then I remember I need to drop the temp table if it exists.. so I start typing
DROP TABLE IF EXISTS # when I get to this point, I wish the intellisense would recommend #mytemptable but it only recommends previous #temp tables. I wish for this type of statement, it would prompt for all #temp tables in the query window.DROP TABLE IF EXISTS # <-- intellisense here is needed
SELECT *
into #mytemptable
FROM mytable msee image... there is no intellisense
https://imgur.com/a/8xGvfbX1 voteAdminDevart
(_, Devart)
responded
dbForge parses the object only after it’s declared. So, if the table is declared in the INTO clause, it will be offered only below the place it’s declared in the script and not above.
-
SQL Complete does not support parsing SQL with valid PATINDEX function
SQL Complete does not support parsing SQL with valid PATINDEX function
1 voteAdminDevart
(_, Devart)
responded
Could you please provide us the specific example of this?
-
Remove debug stamp in Releases (keep it for your Debug versions only or verbose mode)
Steps to reproduce:
- run app DebugView
- work with SQL Complete for sometime in SSMS
- keep watching DebugView until you'll see lots of debug messages generated by SQLCompleteExpected: no debug messages in Release binaries
Actual: there are debug messagesPlease chekc all other products for this.
1 voteAdminDevart
(_, Devart)
responded
We will fix it in one of the next product builds.
-
Allow the 'on' clause to be aligned with the JOIN clause
"Support" was of no assistance, but I'd like to have my 'On' clause aligned with the join clause, but it's not possible:
from
[ExtendedEvents].[Events] ee -- on new line
join
OtherTable
on -- inline with JOIN
OtherTable.[ID] = ee.[ID]
where1 voteAdminDevart
(_, Devart)
responded
This can be setup as follows:
1. Select ‘SQL Complete → Options…’ from the main menu. The ‘Options’ window opens.
2. Navigate to the ‘Formatting → Profiles’ branch.
3. Select the active profile and click the ‘Open Selected…’ button.
4. Navigate to the ‘SELECT → FROM → JOIN’s’ section.
5. Unselect the ‘Indent ON keyword by 4 columns’ option. -
In 'where' clause align the conditions to allow easier column selection
"Support" were or no assistance. I'd like to align the where clause so that I can column select the conditions, bu aligning the logical operators with the where clause:
where
[collectionid] > 5396 -- alignment
and [sessionid] = 114 -- alignmentcurrently the code gets formatted as:
where
[collectionid] > 5396 -- alignment
and [sessionid] = 114 -- alignment1 voteAdminPMs
(Admin, Devart)
responded
Could you please provide us screenshots of the actual and expected results along with the script?
- Don't see your idea?