310 results found
-
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
-
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?
-
Alias casing variation between columns and table Alias
When creating a formatting profile there is only one selection for Alias casing, in my personal experience my column alias casing differs from my table alias.
EX:
Select
det.name AS UserName
, det.id AS UserId
, det.phone AS UserPhone
, det.description AS UserBio
FROM dbo.exampletable detwhen running through my formaterr with the setting Alias Case set to 'Lower' it changes my column alias's whether they are snake_Case PascalCase to lower
TLDR : have a setting to alter column alias case individually rather than a global alias case option
1 voteAdminDevart
(_, Devart)
responded
Unfortunately, we cannot reproduce the problem. Please, provide us with the following information:
- which version of dbForge product are you using;
- the whole script that we need to format (not a part of the code, but the entire document).We also want you to check that you are editing the settings for the active formatting profile. Note: the active formatting profile is given in bold in the profiles grid on
SQL Complete – Options – Formatting – Profiles -
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.
-
Alias CTE like tables
When referencing a CTE, the CTE name is also its alias instead of the shortened version. E.g. the CTE NewUsers doesn't get aliased as "nu". Also, when typing "SELECT * FROM NewUsers", navigating to the "*" and hitting tab to expand columns, the expanded column names aren't prefixed with an alias or table name. This could just be a settings issue
1 voteAdminDevart
(_, Devart)
responded
Could you please describe it in more detail and provide us the scripts?
Screenshots would be also of help.
-
Server Color
There is server coloring in the project. But there are only a few colors I can choose. If I can do it like in SSMS Tool Pack, I can choose any color for the server
1 voteAdminDevart
(_, Devart)
responded
You might be referring to the Tabs Color feature that can be setup in the ‘Tabs Color’ section of the ‘Options’ window (select ‘SQL Complete → Options…’ from the main menu).
-
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?
-
code completion not working when db is offline
when db is offline during ssms startup - it won't get code completion.
you have to bring it online and restart ssms1 voteAdminDevart
(_, Devart)
responded
Could you please clarify if it does not work only for offline databases or for each database on the server?
A video or screenshots would be also of help.
- Don't see your idea?